I came across a spreadsheet where both the columns and rows were numbered 1-2-3. How do I change the columns back to letters.
I came across a spreadsheet where both the columns and rows were numbered 1-2-3. How do I change the columns back to letters.
Click on Tools > Options > General and check R1C1 reference style to show numbers or un-check to show letters.
In the "Tools" menu choose "Options", you will see the dialog "Options" which has several tabs, choose the one that says "General". Among the options on this tab, check if it is on the box indicating "R1C1 reference style", disable and click on "OK" and you should be back in the letters column labels .
Bookmarks