How to change the column headers from ABC to 123

  • Thread starter Thread starter Wendyk21
  • Start date Start date
W

Wendyk21

The columns across the top of my spreadsheet use to say ABC. When I opened
up Excel today they have changed from ABC to 123. Now all of my previous
worksheeets with formulas can't read and gives me ERROR. How do I change
them back to say ABC
 
In XL2003: menus Tools>Options>General tab>R1C1 Reference style
In XL2007: Office Button>Excel Options> Formulas>'Working with formulas'>
R1C1 reference style

If this post helps click Yes
 
<2007 excel:
Tools, Option, General tab, uncheck R1C1 reference style

2007 excel:
big office button, Excel options, Formulas, uncheck same box

:)
susan
 
Back
Top