Forum Discussion
Column labels became numbers instead of letters
I reinstalled office 365, and Excel now shows numbers for columns rather than letters. Is this optional? Tom
Hmm, I have turned off R1C1 reference style, and the Name box correctly shows references with letters for columns, but still the columns themselves are labelled Column1, Column2 etc... I just want to see A, B, C etc...
What do I need to do? It's only with one file...
Regards, Peter
What do I need to do? It's only with one file...
Regards, Peter
Does that sheet contain a table? If you scroll a sheet with a table while the active cell is inside the table, the column letters A, B, C etc. will be replaced with the column headers of the table.