ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make Excel column headers alphabetical... (https://www.excelbanter.com/excel-discussion-misc-queries/90230-how-do-i-make-excel-column-headers-alphabetical.html)

njord10

How do I make Excel column headers alphabetical...
 
My column headers suddenly seem to have gone numeric instead of
alphabetic.How do I change them back. I'm using Excel 2002


How do I make Excel column headers alphabetical...
 
Hi

Go to Tools/Options/General and uncheck R1C1 style.

Andy.

"njord10" wrote in message
...
My column headers suddenly seem to have gone numeric instead of
alphabetic.How do I change them back. I'm using Excel 2002




Norman Jones

How do I make Excel column headers alphabetical...
 
Hi N,

Try:

Tools | Options | Genereal | deselect R1C1 reference sttle option


---
Regards,
Norman



"njord10" wrote in message
...
My column headers suddenly seem to have gone numeric instead of
alphabetic.How do I change them back. I'm using Excel 2002





All times are GMT +1. The time now is 06:07 AM.

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