ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change headings for columns from numbers to letters? (https://www.excelbanter.com/excel-discussion-misc-queries/55398-how-do-i-change-headings-columns-numbers-letters.html)

scott

How do I change headings for columns from numbers to letters?
 


Chip Pearson

How do I change headings for columns from numbers to letters?
 
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


"scott" wrote in message
...




Rowan Drummond

How do I change headings for columns from numbers to letters?
 
ToolsOptionsGeneral. Uncheck R1C1 reference style.

Regards
Rowan

scott wrote:

Max

How do I change headings for columns from numbers to letters?
 
Tools Options General tab
Uncheck "R1C1 reference style" OK

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"scott" wrote in message
...

How do I change headings for columns from numbers to letters?




All times are GMT +1. The time now is 04:17 PM.

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