ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change column labels from numbers to letters in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/1559-how-do-i-change-column-labels-numbers-letters-excel.html)

AllisonCincy

How do I change column labels from numbers to letters in Excel?
 
In Excel, my column headers somehow changed from letters to numbers. How do
I get the letter headings back?

For example, I can no longer reference cell C3 because the C is now a
number.

Norman Jones

Hi Allison,

Try:

Tools | Options | General | Check R1C1 Reference Style

---
Regards,
Norman



"AllisonCincy" wrote in message
...
In Excel, my column headers somehow changed from letters to numbers. How
do
I get the letter headings back?

For example, I can no longer reference cell C3 because the C is now a
number.




Norman Jones

Hi Allison,

Check R1C1 Reference Style

Should have read:

UNCheck R1C1 Reference Style


---
Regards,
Norman



"AllisonCincy" wrote in message
...
In Excel, my column headers somehow changed from letters to numbers. How
do
I get the letter headings back?

For example, I can no longer reference cell C3 because the C is now a
number.





All times are GMT +1. The time now is 01:24 PM.

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