ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change the labels of my columns from numbers to letters? (https://www.excelbanter.com/excel-discussion-misc-queries/77207-how-do-i-change-labels-my-columns-numbers-letters.html)

Anna-Maria

How do I change the labels of my columns from numbers to letters?
 
Up until yesterday, the labels at the top of my spreadsheets were letters
(A,B,C...). Today they are numbers (1,2,3...). How do I change them back,
and what might have happened to cause this?

Anna-Maria

davesexcel

How do I change the labels of my columns from numbers to letters?
 

You are probably in R1C1 reference style
goto
tools=options=general and uncheck it


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522298



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

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