Column headings display as a numbers

  • Thread starter Thread starter Cynthia
  • Start date Start date
C

Cynthia

Occasionally when I launch excel the column headings and row are displayed as
numbers. As a result if you click in cell A1 it will display in the cell
reference box as R1C1. Thus I can not figure out how to type in formulas or
review them since I have not idea what these references mean.
 
Excel picks up this setting from the first workbook you open in that session.
If you're unlucky enough that your first workbook opened is in R1C1 reference
style, you'll have to make the change.

Do you save the workbook after you make the change to A1 reference style?

Do you have a coworker who likes R1C1 and saves it that way? (Could mean a
fight!)
 
Excel picks up this setting from the first workbook you open in that session.
If you're unlucky enough that your first workbook opened is in R1C1 reference
style, you'll have to make the change.

Do you save the workbook after you make the change to A1 reference style?

Do you have a coworker who likes R1C1 and saves it that way? (Could mean a
fight!)
 
Excel picks up this setting from the first workbook you open in that session.
If you're unlucky enough that your first workbook opened is in R1C1 reference
style, you'll have to make the change.

Do you save the workbook after you make the change to A1 reference style?

Do you have a coworker who likes R1C1 and saves it that way? (Could mean a
fight!)
 
Oops.

Sorry about the multiple posting.



Dave said:
Excel picks up this setting from the first workbook you open in that session.
If you're unlucky enough that your first workbook opened is in R1C1 reference
style, you'll have to make the change.

Do you save the workbook after you make the change to A1 reference style?

Do you have a coworker who likes R1C1 and saves it that way? (Could mean a
fight!)
Click to expand...
 

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

Can I change the column heading from alphabetic to numeric? 2
Column Heading Error 3
Column Headings 1
Is it possible to hide column headings & row numbers? 2
Excel Column Headings Numeric to Alpha 1
How can I change column titles back to numbers? 4
Why are my column headings numerical instead of alphabetical? 1
reference format and column name 1

Back
Top