Why are my Excel columns numbered and not alphabetized (A..ZZ)?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Opening up Excel the other day, I noticed that the spreadsheet columns were
numbered (1..n) instead the normal alphabetized (A..ZZ). This seems to be a
general setting that I do not know how got changed and thus can't change
back. Any ideas?
 
Tools > Options > on the 'General' tab uncheck 'R1C1 reference style'
Regards,
Alan.
 
Tools>Options>General.

Uncheck R1C1 reference Style


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

columns showing numbers instead of alphabets 1
format Column with horizontal alphabet label 3
Column headings to numbers and row headings to alphabets? 2
why my columns in excel are no longer alphabetized? 5
Changing column headers from alphabetical characters to numbers? 2
Why are my column headings numerical instead of alphabetical? 1
My Column display as "numbers" instead of "alphabets" 1
Alphabetizing Column without losing corresponding data? 2

Back
Top