If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|