ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Columns Labeled (https://www.excelbanter.com/excel-discussion-misc-queries/139342-columns-labeled.html)

Wendy

Columns Labeled
 
The columns in my excel are labeled as 1,2,3, etc. how do I change them back
to being labeled A,B,C, etc.

Bob Flanagan

Columns Labeled
 
Select Tools, Options, General and uncheck R1C1 style.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Wendy" wrote in message
...
The columns in my excel are labeled as 1,2,3, etc. how do I change them
back
to being labeled A,B,C, etc.





All times are GMT +1. The time now is 01:18 AM.

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