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

Top