How can I change column titles back to numbers?

G

Gamer

When I created a current spreadsheet it had the normal alphas as column
headings. Now for some reason (don't know what I did) they have changed to
numbers and now the cell address for A1 is R1C1. How can I change it back?
 
K

Kevin B

Click TOOLS in the menu & select OPTIONS. Click the GENERAL tab in the
OPTIONS dialog box and remove the check mark from the R1C1 REFERENCE STYLE
checkbox.
 

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

Column headers numbers instead of letters 2
Excel 2007... fix column headings from numbers back to letters 4
Column headings display as a numbers 7
Changing grey column headings from numbers back to capital letters 2
How to change rows, columns to alpha numerical 2
Column chngd fm letters to numbers. What that & how do I go back? 1
Excel Column Headings Numeric to Alpha 1
How to change column labels back to letters? 1

Top