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?

Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3
 

Excel 2003:-
ToolsOptionsGeneralUncheck the R1C1 Reference Style checkbox and give ok

Excel 2007:-
Click the Office Ribbon Button (colorful round circle at the top Left
corner)Excel OptionsFormulasWorking With Formulas Uncheck the R1C1
Reference Style checkbox and give ok.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Gabbai" wrote:

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?