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.
HansVogelaar Thanks for the quick response.
Easiest to show you. You can see the column headings.
Regards, PeterIt does look like the active cell is in a table
So maybe it is in a table... It doesn't make any difference where I click on te page, the headers remain. So the issue remains, what do I have to do to fix it? It's a pain in the bum like it is!
Regards, Peter