ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change my column headings from numbers to alpha (https://www.excelbanter.com/excel-discussion-misc-queries/112516-how-do-i-change-my-column-headings-numbers-alpha.html)

Ragman

How do I change my column headings from numbers to alpha
 
My column headings have suddenly become numbers instead od lettters. How do
I change tehm back to letters?

Dave Peterson

How do I change my column headings from numbers to alpha
 
Tools|Options|General Tab|Uncheck R1C1 Reference Style



Ragman wrote:

My column headings have suddenly become numbers instead od lettters. How do
I change tehm back to letters?


--

Dave Peterson

Gord Dibben

How do I change my column headings from numbers to alpha
 
ToolsOptionsGeneral.

Uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP

On Mon, 2 Oct 2006 15:10:02 -0700, Ragman
wrote:

My column headings have suddenly become numbers instead od lettters. How do
I change tehm back to letters?




All times are GMT +1. The time now is 02:10 AM.

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