How to change the column headers from ABC to 123

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
 
J

Jacob Skaria

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
 
S

Susan

<2007 excel:
Tools, Option, General tab, uncheck R1C1 reference style

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

:)
susan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing column heads from ABC to 123 2
How to change column heading from numerical to alphabetical? 2
How i change back to ABC 5
Formula - to accumulate the number of data appear 2
Text to columns 2
unhide the column labels 3
Column headings changed from ABC to 123 format 2
All column and row headers hidden 1

Top