The column names (A,B,C, etc...) changed to numbers??????????

J

Jenner

I opened a spreadsheet I hadn't opened in a while and all the column names
(usually letters) are numbers now. I tired openeing a blank sheet but this
setting is applied to all of them.

How do I change it back!!! I'm working with formulas and cell references and
this format is impossible.

Thanks
 
D

Dave Peterson

Tools|Options|General Tab|Uncheck R1C1 Reference style
(and save the workbook)

But remember how you changed this. Excel picks this setting up from the first
workbook it opens in that session.

So if you're unlucky and open one of those workbooks that was saved in R1C1
reference style, you'll have to do it again.
 

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 header changed to numbers, how do I change to letters? 3
Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3 1
Why did my Excel column headers change from letters to numbers? 4
Column Labels switched from letters to numbers 1
Column Names 4
de-apply names 2
column & row names printed - a, b, c etc 1
Excel 2007 changed the column Letters into numbers 1

Top