Column Labels

S

Stephanie

I have a coworker who changed the column labels from
letters to numbers. She does not know how she did it. Does
anyone know how to change them back to letters. The
columns are numbered in all of the worksheets that she
opens.

Stephanie
 
H

Harald Staff

Hi Stephanie

Tools > Options, General pane, uncheck R1C1 Reference.
She probably didn't do anything like that, the setting can follow a file.

HTH. Best wishes Harald
 

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

Mail Merge Problem 1
Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f 3
Why are column headings numbers instead of letters? 1
How to change column labels back to letters? 1
Small spreadsheet opens with no toolbars? 2
Unsolicited Emails 12
Column header format 5
column headers 2

Top