Excel is showing numbers as headers for both rows and columns??

G

Guest

How do I change the column headers back to letters? Formulas will still work
if I use r1c1 format, but why did it change from letter headers on columns?
 
D

Dave Peterson

Tools|Options|General Tab
Uncheck the R1C1 reference style button.

Excel will pick this setting from the first workbook that it opens in that
session.
 
G

Guest

Try this... Under Tools, open Options, then select the "General" tab. Under
Settings, see if R1C1 reference style is checked. If it is, clear it. That
should fix your problem.

Good luck!
 

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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Column header changed to numbers, how do I change to letters? 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How do I change my column headers? 1
Excel 2007 change column labels from numbers to letters 8
Excel sheet with numbers as column & row headers - How? 3
Column and Row header 3
Column header format 5

Top