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

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
 
D

Dave Peterson

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.
 
E

essential

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
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Changing grey column headings from numbers back to capital letters 2
Problem formatting pivot table headers 3
Columns now numbers rather than letters how do i get letters back 2

Top