How do I change my column headers?

M

mrockwood

My Column headers are numbers (1,2,3) instead of letters (A,B,C). How do I
fix this?
 
D

Dave Peterson

in xl2003 menus:
Tools|Options|General tab
uncheck R1C1 Reference style

In xl2007:
Office button|Excel Options|Formulas|Working with formulas
uncheck R1C1 Reference style


Excel picks up this setting from the first workbook you open in that session.

If you have a co-worker who likes R1C1 Reference Style and you're unlucky enough
to open a workbook that he saved as the first workbook in that session, you'll
be making the same change 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

Excel is showing numbers as headers for both rows and columns?? 2
Change color of row and column worksheet headers 2
Excel sheet with numbers as column & row headers - How? 3
Change Column gridlines headings A,B,C.....versus 1,2,3.... 1
Colunmn headers 4
How to switch column headers from numbers back to letters? 2
Column caption 2
How do I sum a column based on 2 different column headers/criteria? 0

Top