How do I change excel column heading from numeric to alphabetic?

B

bones21

My spreadsheet column headings changed fom aphabetic to numeric. I would like
to know how to change them back to alphabetic. I just asked this question and
received an answer. However the answer never appeared, just a blank page.
 
J

John

HI Again
Will try once moore:
Goto>Tools>Options>General>uncheck R1C1 reference style.
HTH
John
 
S

Suleman Peerzade

Hi,

In the menubar Tools>>Options>>General>>Uncheck the R1C1 reference style>>OK
you will get the column headings back in alphabetical order.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade
 
Joined
Aug 22, 2012
Messages
2
Reaction score
0
My spreadsheet column headings changed fom aphabetic to numeric. I would like
to know how to change them back to alphabetic. I just asked this question and
received an answer. However the answer never appeared, just a blank page.





<< try this .. for excel 2010;
click File, ; Option ; select tab ; Formula and then unchecked the R1C1 reference. :D
 

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