How can I change column titles back to numbers?

  • Thread starter Thread starter Gamer
  • Start date Start date
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?
 
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.
 
Tools, Options, General tab and remove tick in R1C1 box.

Regards
Peter
 
In xl2003 menus:
Tools|Options|General tab|uncheck R1C1 reference style.
 
You must log in or register to reply here.

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

How to change rows, columns to alpha numerical 2
Column headers numbers instead of letters 2
Excel 2007... fix column headings from numbers back to letters 4
Excel Column Headings Numeric to Alpha 1
How can I change column designation from number to letters? 3
How change worksheet axis to alpha numerical not both numer 1
Column headings display as a numbers 7
change column heading names from numbers to alpha characters 3

Back
Top