ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do i change the heading of excel columns to alphabetical (https://www.excelbanter.com/excel-discussion-misc-queries/55507-how-do-i-change-heading-excel-columns-alphabetical.html)

ThePubLounger

How do i change the heading of excel columns to alphabetical
 
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

How do i change the heading of excel columns to alphabetical
 
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

"ThePubLounger" wrote
in message
...
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.




Mladen_Dj

How do i change the heading of excel columns to alphabetical
 
Tools-Options-General, uncheck "R1C1reference style".



"ThePubLounger" wrote in message
...
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.




ThePubLounger

How do i change the heading of excel columns to alphabetical
 
Thx


Foremost19

How do i change the heading of excel columns to alphabetical
 
Thanks, it really helped.
--
J


"Mladen_Dj" wrote:

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



"ThePubLounger" wrote in message
...
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.






All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com