ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column headings are numeric rather than alphabetic (https://www.excelbanter.com/excel-discussion-misc-queries/128483-column-headings-numeric-rather-than-alphabetic.html)

kevpet

Column headings are numeric rather than alphabetic
 
My column headings have unexpectedly changed from letters to numbers. How
can I change them back to letters? Thanks!

Chip Pearson

Column headings are numeric rather than alphabetic
 
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
(email address is on the web site)

"kevpet" wrote in message
...
My column headings have unexpectedly changed from letters to numbers. How
can I change them back to letters? Thanks!





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

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