Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change default cell referencing in excel from R1C1 to A1?
It's driving me nuts - it should be so simple and yet it's impossible to find
out from the help section. All I want to do is change my default settings back to the way Excel used to have them so the columns are referenced by letters instead of numbers (eg A1 not R1C1). I loathe Excel 2007 with a passion - I find it completely unintuitive. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change default cell referencing in excel from R1C1 to A1?
office button excel option formulas R1C1 reference style (check)
"Hackedoffwith2007" wrote: It's driving me nuts - it should be so simple and yet it's impossible to find out from the help section. All I want to do is change my default settings back to the way Excel used to have them so the columns are referenced by letters instead of numbers (eg A1 not R1C1). I loathe Excel 2007 with a passion - I find it completely unintuitive. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Cancel r1c1 cell referencing in excel 2007 | Excel Discussion (Misc queries) | |||
how do I change cell labelling from R1C1 to A1? | Excel Discussion (Misc queries) | |||
How do I change default cell reference from 'R1C1' to 'A1'? | Setting up and Configuration of Excel | |||
R1C1 referencing | Excel Worksheet Functions | |||
How do I change excel sheet from R1C1 for cells to A1 for cell? | Excel Worksheet Functions |