| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Columns headings have changed to numbers instead of letters
All my worksheets now appear with numbers in the column labels. e.g. instead
of a cell reference being A1 it now appears as R1C1. When developing formulas, the cell reference counts the number of positions I've moved the cursor. For instance if I move two columns to the right and two rows down it is referred to as R(2) C(-2) - two postion move backwards from the origninal column and two rows down. This makes it impossible to identify the cell you are pointing to in a formula. How do I change the column back to the letter system? -- Have a great day. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Columns headings have changed to numbers instead of letters
Tools Options General clear the R1C1 checkbox.
-- Gary''s Student - gsnu200768 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Columns headings have changed to numbers instead of letters
Tools/ Options/ General
Uncheck R1C1 reference style. -- David Biddulph "DianeC" wrote in message ... All my worksheets now appear with numbers in the column labels. e.g. instead of a cell reference being A1 it now appears as R1C1. When developing formulas, the cell reference counts the number of positions I've moved the cursor. For instance if I move two columns to the right and two rows down it is referred to as R(2) C(-2) - two postion move backwards from the origninal column and two rows down. This makes it impossible to identify the cell you are pointing to in a formula. How do I change the column back to the letter system? -- Have a great day. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell 2000--My column headings have changed from letters to numb | 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) | |||
| How do I change headings for columns from numbers to letters? | Excel Discussion (Misc queries) | |||
![DianeC[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
