| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing the headers on an excel worksheet from Numbers back to le
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the headers on an excel worksheet from Numbers back to le
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. Maxine wrote: 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the headers on an excel worksheet from Numbers back to le
Tools|Options|General tab
uncheck R1C1 Regards Cimjet "Maxine" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the headers on an excel worksheet from Numbers back to le
Try
Tools|Options|General Un-Check R1C1 reference style Mike "Maxine" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the headers on an excel worksheet from Numbers back t
Thanks to all three of you - it worked!
"Cimjet" wrote: Tools|Options|General tab uncheck R1C1 Regards Cimjet "Maxine" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the headers on an excel worksheet from Numbers back t
What if it's changing automatically?
What macro might I use to force it to keep R1C1 unchecked? "Mike H" wrote: Try Tools|Options|General Un-Check R1C1 reference style Mike "Maxine" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In MS Excel, how do I change the column ref headers from numbers . | Excel Discussion (Misc queries) | |||
| How do I get my column headers to go back to alphabetical? | Excel Discussion (Misc queries) | |||
| Changing the Column Headers back to letters from #s | Excel Discussion (Misc queries) | |||
| How to switch column headers from numbers back to letters? | Excel Worksheet Functions | |||
| My Excel column headers have changed to numbers, how do I get bac. | Excel Discussion (Misc queries) | |||
Linear Mode
