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

Excel does not accept text format! 0
I have lost 6 months work, how can i get my file back 1
(headers & footers Issue) I have 2 even pages back to back!! 1
Column headers numbers instead of letters 2
Excel 2007... fix column headings from numbers back to letters 2
how can i change a sequence of numbers using find replace 2
Changing grey column headings from numbers back to capital letters 2
Column headings display as a numbers 7

Top