column designation has started to appear as numbers

G

Guest

All of a sudden the designation of columns has appeared as numbers (as well
as the rows) on some spreadsheets. It makes it difficult to track formulas.
 
G

Guest

Thank you very much. I was in the Options section last week and must have
inadvertently checked that box. It has had me frustrated since.
Bert
 
D

Dave Peterson

This setting is picked up from the first workbook you open in that excel
session.

If you share a workbook with a co-worker and that co-worker likes R1C1, you may
find that you have to toggle this setting again (and again and again...).

You'll want to remember how to do it (or just yell at that co-worker!)
 

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

separate names and designation from one cell into 2 colmun 5
Dependent list in excel to create validation 1
How can I keep 2 rows of column headings out of sort data? 1
Look & return values, in cells with numbers & words 4
Column Heading Error 3
I need help with my macros. 3
Using excel like a check register 1
How can I change column designation from number to letters? 3

Top