Changing the headers on an excel worksheet from Numbers back to le

  • Thread starter Thread starter Maxine
  • Start date Start date
M

Maxine

Hi

I have somehow managed to change my worksheet default to have column numbers
rather than letters, and its driving me mad! Does anyone know how to change
them back?

Many Thanks

Maxine
 
In xl2003 menus, it's:
Tools|Options|General Tab|Uncheck R1C1 Reference style

Excel picks up this setting from the first workbook you open in that session.
 
What if it's changing automatically?

What macro might I use to force it to keep R1C1 unchecked?
 

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

How to Change Column Header from numbers back to letters 2
Editing an "IF" function across a worksheet/excel file 2
numbering pages in footer 1
Showing Letters For Column Headers Rather Thann Numbers ? 1
Changing grey column headings from numbers back to capital letters 2
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
How to change the number of rows in a worksheet. 2
Change numbers in a worksheet using the $ function. 2

Back
Top