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

Similar Threads

Change the column designation from a numeric to an alpha 2
how do I column heading to alpha from Numeric? 1
separating alpha numeric vlue 23
How do i change column header from R[1] C format to A1 format? 4
How can I change column headers from numeric to alpha? 2
Format of column need to change back to Alpha not numeric 1
Column and Row Labels 1
Row/Column Headers 2

Top