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

  • Thread starter Thread starter bones21
  • Start date Start date
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.
 
HI Again
Will try once moore:
Goto>Tools>Options>General>uncheck R1C1 reference style.
HTH
John
 
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
 
bones21 said:
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.
Click to expand...





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