row and col ref are all num how can I get it back to letters?

J

Julio

in excel 2007 my column and row references are all numbers all of a sudden.
How can I get the column references back to letters?
 
S

Sheeloo

To turn R1C1 referencing on or off in Excel 2007:

1. Click the Office Button.
2. Click Excel Options.
3. Switch to the Formulas tab.
4. Click the R1C1 reference style check box. A filled box will enable R1C1,
a cleared box will disable it.
5. Click 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

hide col letters and row numbers 4
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
Columns now numbers rather than letters how do i get letters back 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
Row & Column Headings 2
Showing Letters For Column Headers Rather Thann Numbers ? 1
Why does my Excel shows the rows and the columns as numbers? 4
Hiding rows and columns in XL 07 3

Top