Column labels

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

Guest

For some unknown reason all my column labels have changed from letters to
numbers. Can anyone tell me how to change them back to letters, please?
 
Tools>Options>General tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| For some unknown reason all my column labels have changed from letters to
| numbers. Can anyone tell me how to change them back to letters, please?
| --
| Thanks and look forward to any help you can give.
 
Click Tools,Options then uncheck the R1C1 reference style checkbox on the
General tab
 
Hi Steve,
Tools, Options, General, uncheck R1C1 reference style
 
Tools|Options|General Tab|Uncheck R1C1 Reference style

Excel uses whatever the first workbook opened in that session uses. If you're
unlucky enough to open a workbook that's in R1C1 reference style as the first
workbook, you'll have to toggle this setting again.
 
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

Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f 3
How to change column labels back to letters? 1
column headers 2
Column header format 5
column labels 2
Column headers numbers instead of letters 2
how do I change column headers from a number to a letter 2
Column Labels 3

Back
Top