Hello, I'd like to be able to create collapsible sections in an Excel worksheet (2003). So a column would appear down the left-hand side which would have the...

How do I make a cell only display the name of the sheet? without writing e.g "sheet1" Is there a formula such as =sheetname ?

Using Excel 2000 I'm constantly getting the message "Cannot empty clipboard" whenever I copy the contents of a cell to another. Even happens directly after...

I have a detail General Ledger Account data file (please see below) that needs to have a column (FRPT MAPPING) to map each account transaction to a specific...

I have a column (Column A) of text data in one column with anywhere between 1 and 144 rows of unique text data. Next, in Column B, I have another series of...

I installed the Analysis ToolPak add-in this morning, was using it for a couple hours, and now it's disappeared. No idea why- I haven't mucked with any of...

Hi Guys, I have drawn a blank. Please help? I have a spreadsheet which affectively are all items from my bank statement. In another spreadsheet I have all...

I get an error message everytime I open Excel 2007, it just says "stdole32.tlb" and a button for OK. When I click OK it starts reconfiguring like the first...

I need there to be a dash at every certain number on points in a chart, for instance 1 every 12 for the year even though there is data monthly.

I am trying to set up a spread sheet to calculate inventory. I need to add some items in feet and some in inches. I need to know first do I set these up at...

I get a bothersome Bubble that tells me it has sent a document to the printer, how do I fade it or make it go away?

I would like to build a formular to calculate pricing based on 40% off list.

I have a form in word that is distributed to various people and then sent back to a central location. Is there a way to get the fields in that form feeding...

The program is slow to open and keeps pausing while I am trying to enter info. The macros run fine. I have Norton anti virus; Do I need to change a security...

My column headings have mysteriously changed from alpha (letters) to numbers. How do I change the column headings back to letters? Thanks

Hi and thank you in advance I have 2 different worksheets. The one worksheet (call it the catalogue for ease) has product codes and descriptions etc. The...

I am using Excel 2003 and I used to 'send" a copy of one worksheet using outlook to other team members. Now those members that have Excel 2007 receive the...

I am using Excel 2003 and I used to 'send" a copy of one worksheet using outlook to other team members. Now those members that have Excel 2007 receive the...

Stock quotes in Excel 2007 are supposed to work via Smart Tags. Well, I have them working ok for people's names, but when I enter "MSFT" into a call, it will...

I have 4 CF's set on range B6:J6. The range fill color will change based on the value of cell D6. If D6=1 then the fill color is red, D6=2 yellow and D6=3...