| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What causes column headings in Excel to change from A, B, to 1,2?
Using Excel 2003 sometimes the column headings change from A, B, C, etc to 1,
2, 3, etc. The rows maintain their headings of 1, 2, 3 but only the column headings change. This makes the creation of formulas difficult. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What causes column headings in Excel to change from A, B, to 1,2?
Richard
ToolsOptionsGeneral. Uncheck "R1C1 reference style". This a user-generated change from unchecked mode. Gord Dibben MS Excel MVP On Thu, 29 Jun 2006 09:43:01 -0700, Richard wrote: Using Excel 2003 sometimes the column headings change from A, B, C, etc to 1, 2, 3, etc. The rows maintain their headings of 1, 2, 3 but only the column headings change. This makes the creation of formulas difficult. Thanks. |
| 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) | |||
| change excel auto column headers from numeric to alpha | Excel Discussion (Misc queries) | |||
| What will cause column headings to change from letter to number? | Excel Discussion (Misc queries) | |||
| how do I change a line series to a column series in excel? | Charts and Charting in Excel | |||
| How can I see column headings of hidden columns in Excel before u. | Excel Discussion (Misc queries) | |||
Linear Mode
