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

G

Gabbai

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?
 
M

Ms-Exl-Learner

Excel 2003:-
Tools>>Options>>General>>Uncheck the R1C1 Reference Style checkbox and give ok

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

Remember to Click Yes, if this post helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column headings - urgent help needed please 3
column headings 3
Column headings 2
Excel 2007... fix column headings from numbers back to letters 4
column & row names printed - a, b, c etc 1
excel-why do the columns A B C D etc and 1 2 3 4 etc print? 2
What causes column headings in Excel to change from A, B, to 1,2? 1
Excel Write a formula in excel where 1 = .05, 2 = .75, 3 = .30 etc. 4

Top