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

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Column headings - urgent help needed please 3
column headings 3
Possible to Combine reports to's to a single box? 0
excel-why do the columns A B C D etc and 1 2 3 4 etc print? 2
Column headings 2
How to rename the head A,B,C,D,E etc. on every column 0
Problem with Column header ID being 1 2 3 etc instead of A B C etc 2

Top