| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CELL REFERENCE
The cell references on my spreadsheet are numbers. How can i change the top
reference back to letters ? The cell reference there fore reads R12C1 instead of A12 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CELL REFERENCE
Menu ToolsOptions and go to the General tab, and then check the R1C1 Style
checkbox -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pauline" wrote in message ... The cell references on my spreadsheet are numbers. How can i change the top reference back to letters ? The cell reference there fore reads R12C1 instead of A12 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CELL REFERENCE
Hi if I change my spreadsheets will all the formulas automatically change
Thanks for your help "Bob Phillips" wrote: Menu ToolsOptions and go to the General tab, and then check the R1C1 Style checkbox -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pauline" wrote in message ... The cell references on my spreadsheet are numbers. How can i change the top reference back to letters ? The cell reference there fore reads R12C1 instead of A12 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CELL REFERENCE
Pauline,
why don't you try it and see? Pete On Mar 20, 1:28*pm, Pauline wrote: Hi * if I change my spreadsheets will all the formulas automatically change Thanks for your help "Bob Phillips" wrote: Menu ToolsOptions and go to the General tab, and then check the R1C1 Style checkbox -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pauline" wrote in message ... The cell references on my spreadsheet are numbers. *How can i change the top reference back to letters ? The cell reference there fore reads R12C1 instead of *A12- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
