Excel 2007... fix column headings from numbers back to letters

K

Kathleen Kent

My column headings have mysteriously changed from alpha (letters) to numbers.
How do I change the column headings back to letters?
Thanks
 
T

T. Valko

Change this setting:

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

T. Valko

Change this setting:

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

Sheeloo

1. Click the Office button and then click on Excel Options. Excel displays
the Excel Options dialog box.
2. At the left side of the dialog box, click Formulas.
3. If you want to use R1C1 format, select the R1C1 Reference Style check
box; if you want to use A1 format (the default for Excel), clear the check
box.
4. Click on OK.
 
S

Sheeloo

1. Click the Office button and then click on Excel Options. Excel displays
the Excel Options dialog box.
2. At the left side of the dialog box, click Formulas.
3. If you want to use R1C1 format, select the R1C1 Reference Style check
box; if you want to use A1 format (the default for Excel), clear the check
box.
4. Click on 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

Changing grey column headings from numbers back to capital letters 2
Column Heading 1
column headings 3
Column Headings 1
Excel - Column headings 1
Column headings - urgent help needed please 3
Column headings are numeric rather than alphabetic 1
How do I change headings (column name) from numbers to letters? 2

Top