Column header format

B

b_wildman

How can I change the column headers from numbers to letters? Instead of rows
labeled as numbers and columns as letters, they are both numbers. EXCEL 2003.

Thanks for the help.
 
P

Pete_UK

Click on Tools | Options | General tab and unclick R1C1 Reference
Style, then OK.

Hope this helps.

Pete
 
S

Sheeloo

Go to Tools > Options. Pick the General Tab. The first box in the settings
section will be checked ("R1C1 reference style"). Uncheck this box. Click OK.
Your problem should be solved.
 
L

Lynn

Hi John -- any advice on how to change the column labels back to letter in
Excel 2007? I can't find the Tools/Options, general Tab you referenced below
for Excel 2003. Any advice would be appreciated!

Lynn
 
T

T. Valko

In Excel 2007:

Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK
 

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 sheet with numbers as column & row headers - How? 3
Columns are numbers instead of letters 4
Showing Letters For Column Headers Rather Thann Numbers ? 1
column headers changed from letters to numbers, how do I change ba 1
Column headers numbers instead of letters 2
Columns now numbers rather than letters how do i get letters back 2
reference format and column name 1
Colunmn headers 4

Top