| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is my header row numbers instead of letters?
The standard header row used to be letters (A - B - C) and the left column
was and still is numbers (1 - 2 - 3). When I logged in today, my standard header row is now numbers (1 - 2 - 3). If I need to create a formula it's now 11 or 12 instead of A1 or A2. How can I change this back to letters? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why is my header row numbers instead of letters?
In xl2003 menus:
Tools|Options|General Tab|Uncheck R1C1 reference style raula wrote: The standard header row used to be letters (A - B - C) and the left column was and still is numbers (1 - 2 - 3). When I logged in today, my standard header row is now numbers (1 - 2 - 3). If I need to create a formula it's now 11 or 12 instead of A1 or A2. How can I change this back to letters? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why is my header row numbers instead of letters?
Tools Options General clear the R1C1 checkbox
-- Gary''s Student - gsnu200783 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Bar blocks column header letters so I can't paste | New Users to Excel | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| Change the header columes back to letters not numbers | New Users to Excel | |||
| Numbers to Letters? | Excel Discussion (Misc queries) | |||
| create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) | |||
Linear Mode
