Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 3

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't Cancel r1c1 cell referencing in excel 2007	Yasaf Burshan	Excel Discussion (Misc queries)	3	June 24th 08 01:24 PM
R1C1 reference style	Helpme Please[_2_]	Excel Discussion (Misc queries)	5	July 11th 07 11:12 PM
R1C1 reference	Tony S	Excel Discussion (Misc queries)	1	May 10th 05 05:58 PM
Provide a way to turn off auto-checking excel formulas as I type t	ikarius_rb	Excel Discussion (Misc queries)	6	March 23rd 05 12:33 PM
How do I turn off ALL autoformat in Excel ? (I can't even type "J.	Dave a.k.a. Technophobe	Excel Worksheet Functions	2	February 23rd 05 01:46 AM

All times are GMT +1. The time now is 11:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us