Somehow column names in my Excel sheet got changed from A, B, C, ...
to 1, 2, 3, ...
.
Could anyone please tell me how to change the column labels back to A, B, C
?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communitySomehow column names in my Excel sheet got changed from A, B, C, ...
to 1, 2, 3, ...
.
Could anyone please tell me how to change the column labels back to A, B, C
?
In excel 2007, in the Formulas tab of the Options menu, uncheck "R1C1 reference style."