how do I convert column labels back to alphabetic from numeric?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Excel spreadsheet column labels have mysteriously converted to a numeric
format the same as lines. No idea why, I just want to go back to having them
listed as A, B, C etc. Can anyone help please?

many thanks
 
Click the circular office button on the top left, select "Excel Options"
select the formulas menu and under working with formulas change the "R1C1
reference style" so that it is not ticked.

Hope that helps

Paul
 
In versions 2003 or older, click TOOLS in the menu and select OPTIONS. In
the dialog box click the GENERAL tab and turn of the R1C1 REFERENCE STYLE,
which is the first check box in the SETTINGS panel.
 
Back
Top