Headings of columns now have numbers, need to change them to lette

J

JeffL

Today all the headings of my columns of my spread sheets have changed to
numbers. Can someone tell me how to change them back to letters? I'm using
office 2007.

Thanks
 
S

Sheeloo

1. Click the Office button and then click on Excel Options.
2. At the left side click Formulas.
3. clear the R1C1 Reference Style check box
4. Click on OK.--
 
F

Francis

go to Tool >> Options
In General tab >> Settings
uncheck R1C1 reference style
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
D

David Biddulph

Didn't the OP say 2007?
--
David Biddulph

Francis said:
go to Tool >> Options
In General tab >> Settings
uncheck R1C1 reference style
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 

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