Why are my Columns labeled with Numbers rather than letters?

D

DaveM

For some reason, in Excel 2009, all of my column headers are now Numbers
rather than letters. Is there a setting within Excel or a fast-key that
automatically changed this without me looking?
 
S

Sheeloo

Did you mean Excel 2003? If yers, then read on...

To change this behavior, follow these steps:

1. Start Microsoft Excel.
2. On the Tools menu, click Options.
3. Click the General tab.
4. Under Settings, click to clear the R1C1 reference style check box
(upper-left corner), and then click OK.

If you select the R1C1 reference style check box, Excel changes the
reference style of both row and column headings, and cell references from the
A1 style to the R1C1 style.

In Excel 2007
Office Button->Excel Options->FORMULAS->WORKING WITH FORMULAS
click to clear the R1C1 reference style check box
 

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

Problem with SET & REF function 0
Columns now numbers rather than letters how do i get letters back 2
Columns in Excel labeled numbers rather than letters? 2
why are my column headers numbers instead of letters? 2
Columns are Numbers 5
Columns are numbers instead of letters 4
Column headers numbers instead of letters 2
Why did my Excel column headers change from letters to numbers? 4

Top