General

Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3
I copied all my Excel files onto a CD and then transferred them to another computer. All the Column headers have changed from consecutive letters i.e. A, B, C etc. to consectutive numbers 1, 2, 3 etc. I cannot now use the SUM function. How can I get the letters back? ... 17 Mar 2010 11:23

Dynamic autofilter field
Hiya, I want to set an autofilter in my macro, but the autofilter field isn't necessarily always going to be the same number. It will always have the same column header though. Is there a way to change the number to the column header, or make it filter on the 'active column'? Selection.AutoFilter Field:=... 17 Mar 2010 10:14

Cell formating in Excel?
Is there a way to have a scroll bar in a single cell? ... 17 Mar 2010 11:23

custom toolbar
Using Excel 2003, how do I make a custom toolbar show on 2 rows? ... 17 Mar 2010 10:14

automatic backup? 2007 version
With Word, I can to Options/Advanced/Save and choose to Always create backup copy. Then, every time I resave a Word 2007 doc, I get the backup with a ..wbk file extension. I just can't figure out how to do the same with Excel. There is no comparable Options/Advanced/Save choices. I do see in Word the AutoRecov... 21 Mar 2010 17:22

Resolve Error in opening Excel File zip file from a CD?
I have an error 0x80004005 when opening a excel file from a CD. It states it cannot find it's destination ... 17 Mar 2010 06:54

Auto counting
I got dates under column A and days passed by since date in column A in Column B. How do I ask it to auto calculate the days passed with reference to the date in real time. Example: A B 5 march 2010 11days 10 march 2010 6days ... 17 Mar 2010 05:47

I have 138 numbers, how do i get 15 random numbers from my dat
Pleasure to see you around, RD ! Its been quite awhile since I bumped into your responses -- Max Singapore --- ... 17 Mar 2010 02:32

I have 138 numbers, how do i get 15 random numbers from my data?
... 16 Mar 2010 22:07

Create a formula with a moving cell
I need to create a formula that automatically moves to the next cell containing data. I update reports weekly and want a summary formula to include the "new" data in the cell below. Any suggestions? ... 16 Mar 2010 22:07