You know that we have columns and rows in excel, row are numbered 1,2,3 an columns are titled A,B,C,… so forth. But the columns in my Excel are showing 1,2,3,4, instead of A,B,C. The rows are ok 1,3,3,4. This is happening even when I make a new sheet.
I do not remember if I changed the settings. I went to advanced settings, but couldn’t find any option to set back my columns’ title to A,B,C. How can I fix this?
You don’t say what version of Excel you’re using (which makes a difference to the process of navigating to the option you want), but what you’re looking for is an option called ‘Use R1C1 Style’ (or something like that)
2007
That’s strange. Now I opened the software to look for " R1C1 Style" in help section, when I saw that the columns titles are OK, A,B,C.
But there’s one thing. First I opened an old file to review something, then taking a look at the columns, I saw they are OK now.
Thank you Mangetout for your reply.