How do I change numeric column designations to alpha?
 

Sometimes Excel opens with numeric designators on columns and row. I want
alpha on the columns and numeric on the rows. Can I set that in preferences?
If now, how do I change it when it happens (seemingly at random)?

How do I change numeric column designations to alpha?
 

Tools - Options - General - Uncheck R1C1

Excel however remebers the setting from the last workbook opened so don't be
surprised if it changes back.

Any help?

Mike

"Sarah" wrote:

Sometimes Excel opens with numeric designators on columns and row. I want
alpha on the columns and numeric on the rows. Can I set that in preferences?
If now, how do I change it when it happens (seemingly at random)?