Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I turn off R1C1 reference type in Excel 2007?
In Excel 2003 you turn off R1C1 reference type by unchecking "R1C1 reference
type" under Settings in the menu Tools - Alternative - General. However, I'm not capable of finding the very same menu in Excel 2007. Please help. /Br, Magnus |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I turn off R1C1 reference type in Excel 2007?
In EXCEL 2007:-
Office Button (top left hand corner) Excel Options (lower right hand corner) Formulas - make sure that there is no tick in the box called:- R1C1 reference style If my comments have helped please hit Yes. Thanks. "Mag" wrote: In Excel 2003 you turn off R1C1 reference type by unchecking "R1C1 reference type" under Settings in the menu Tools - Alternative - General. However, I'm not capable of finding the very same menu in Excel 2007. Please help. /Br, Magnus |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I turn off R1C1 reference type in Excel 2007?
Hi,
Office Button|Excel options - Formulas -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mag" wrote: In Excel 2003 you turn off R1C1 reference type by unchecking "R1C1 reference type" under Settings in the menu Tools - Alternative - General. However, I'm not capable of finding the very same menu in Excel 2007. Please help. /Br, Magnus |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I turn off R1C1 reference type in Excel 2007?
Alt-T-OFormulas uncheck R1C1 Reference Style.
-- HTH Bob "Mag" wrote in message ... In Excel 2003 you turn off R1C1 reference type by unchecking "R1C1 reference type" under Settings in the menu Tools - Alternative - General. However, I'm not capable of finding the very same menu in Excel 2007. Please help. /Br, Magnus |
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) | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
R1C1 reference | Excel Discussion (Misc queries) | |||
Provide a way to turn off auto-checking excel formulas as I type t | Excel Discussion (Misc queries) | |||
How do I turn off ALL autoformat in Excel ? (I can't even type "J. | Excel Worksheet Functions |