Column headings display as a numbers

[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.

 

[Luke M]

Under Tools - Options, General:
Uncheck R1C1 style reference.

 

[Jacob Skaria]

Uncheck Tools>Options>General>'R1C1' reference style

If this post helps click Yes

 

[Cynthia]

Thank you very much. We had no idea why this happens on occasion.

 

[Dave Peterson]

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!)

 

[Dave Peterson]

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!)

 

[Dave Peterson]

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!)

 

[Dave Peterson]

Oops.

Sorry about the multiple posting.

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!)