ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to change column titles from numbers to letters. (https://www.excelbanter.com/excel-discussion-misc-queries/63266-how-change-column-titles-numbers-letters.html)

mdb60575

How to change column titles from numbers to letters.
 
The columns are labeled in numbers. How do I change this to letters.

Bart Snel

How to change column titles from numbers to letters.
 
mdb60575 schreef:
The columns are labeled in numbers. How do I change this to letters.

Tools Options General switch off R1C1 reference style

Bart Snel

ERR229

How to change column titles from numbers to letters.
 
ToolsOptionsGeneral
Deselect R1C1 reference style
--
ERR229


"mdb60575" wrote:

The columns are labeled in numbers. How do I change this to letters.


Casey

How to change column titles from numbers to letters.
 

Hi,
Go to ToolsOptionsGeneralunselect "R1C1 reference style"

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=498333



All times are GMT +1. The time now is 03:47 AM.

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