Column names are 1,2,3,....

  • Thread starter Thread starter G. Sawyer
  • Start date Start date
G

G. Sawyer

I just noticed today that the column names in my excel
spreadsheets are no longer alphabetical, but are
numerical. The column marked "1" is defined by excel as
column "1C", and row "1" is defined as row "1R".

How can I get the column names to change back to the
alphabet?

Thanks
 
Hi! G!

Use:

Tools > Options > General
Remove check from "R1C1 reference style"

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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: reset the column headings from numeric to alphabetic? 1
format Column with horizontal alphabet label 3
How to sort entire spreadsheet by one column sort 5
Alpha to Numeral column name 3
Alphabetizing Column without losing corresponding data? 2
COLUMN HEADING CHANGED FROM ALPHABET TO NUMERIC 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Having Blank Cells, etc. ? 1

Back
Top