ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   wise ass who changed column headers to numbers instead of letter (https://www.excelbanter.com/excel-discussion-misc-queries/62083-re-wise-ass-who-changed-column-headers-numbers-instead-letter.html)

SteveG

wise ass who changed column headers to numbers instead of letter
 

I know your bitching to MS but this may help. It's probably because
someone changed your options to R1C1 reference style. Check
ToolsOptionsGeneralSettings. If the R1C1 checkbox is checked,
uncheck it and click on OK. Your column headers should be letters
again.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=496394



All times are GMT +1. The time now is 09:15 PM.

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