| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Columns headings changed to numbers in all of my worksheets
Recently, and I do not know how, all of the column headings in all of my
worksheets changed to numbers (i.e. 1-4) as opposed to letters (as they are supposed to be). Any ideas on how I can change the default settings of Excel 2003 to give me letters for the column headings again (preferably for all worksheets)? I much prefer A1 as a reference to a specific cell than R1C1. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Columns headings changed to numbers in all of my worksheets
Goto the menu ToolsOptionsGeneral tabuncheck R1C1 reference styleOK
-- Biff Microsoft Excel MVP "thunderhead" wrote in message ... Recently, and I do not know how, all of the column headings in all of my worksheets changed to numbers (i.e. 1-4) as opposed to letters (as they are supposed to be). Any ideas on how I can change the default settings of Excel 2003 to give me letters for the column headings again (preferably for all worksheets)? I much prefer A1 as a reference to a specific cell than R1C1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns headings have changed to numbers instead of letters | Excel Worksheet Functions | |||
| I want to get rid of columns with numbers as headings, how do I? | Excel Discussion (Misc queries) | |||
| Row headings have changed from letters to numbers. How do I undo? | Excel Discussion (Misc queries) | |||
| How do columns headings change from letters to numbers? | Excel Discussion (Misc queries) | |||
| How do I change headings for columns from numbers to letters? | Excel Discussion (Misc queries) | |||
Linear Mode
