how do I cahnge column headings from numbers to letters

N

Niek Otten

Tools>Options, General tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
A

Andy Wiggins

Tools > Options: General, then uncheck "R1C1 reference style", and click on
OK
 
K

KL

Hi,

menu Tools>Options, tab 'General', uncheck option 'R1C1 reference style'.

Regards,
KL
 
B

Blairlyng

Thank you so much Niek, you have saved my day. feel free to e-mail me when
you want to visit Scotland paul
 

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

How to rename the head A,B,C,D,E etc. on every column 0
Column heading is numeric. How to change to Alphabet? 1
Missing Row Column Numbers Not Column Letters 1
How do I get Excel column headings to be letters not numbers? 3
I want to get rid of columns with numbers as headings, how do I? 0
columns and rows labeled the same (cell 1-1 vs a-1) how do I chang 6
the cell refs at the top changed to numbers, how go back lettters 1
my column headings are numbers instead of letters.how do i fix 0

Top