How do I change numeric column designations to alpha?


G

Guest

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)?
 
Ad

Advertisements

G

Guest

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
 

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

Top