How do i change the heading of excel columns to alphabetical

[ThePubLounger]

For some random reason the columns in Excel 2002 recently changed from
Alphabetical to Numerical, this is a big pain in the backside when trying to
enter Functions.

 

[Chip Pearson]

Go to the Tools menu, choose Options, then the General tab.
There, uncheck the "R1C1 reference style" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

in message
news[email protected]...

 

[Mladen_Dj]

Tools->Options->General, uncheck "R1C1reference style".

 

[ThePubLounger]

Thx

 

[Foremost19]

Thanks, it really helped.
--
J

Tools->Options->General, uncheck "R1C1reference style".