Posted to microsoft.public.excel.misc

Dave

external usenet poster

Posts: 1,388

Writing formulas between sheet

I'm having a problem that I've never encountered in my 10+ years of using
Excel. If I begin to write a formula in a cell in Sheet1 and try to link it
to a cell in Sheet2, when I hit Enter the formula ends up entering itself not
in Sheet1 (where I started), but instead in Sheet2. I'm sure this is just a
setting I switched on somewhere. Does anyone know how to turn this off?

--
Dave

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
writing if formulas	mafarmer	Excel Worksheet Functions	1	December 5th 06 03:07 PM
Display Improvement for Writing Formulas	Brian Preston	Excel Worksheet Functions	1	July 5th 06 01:56 PM
Need help writing formulas in excel using ratios	Excel Hack	Excel Discussion (Misc queries)	0	February 15th 06 11:40 PM
Problem writing Excel formulas via ODBC	srikantha	Excel Discussion (Misc queries)	0	June 21st 05 08:24 AM
Writing Formulas	Irv	Excel Worksheet Functions	2	December 28th 04 09:25 PM

All times are GMT +1. The time now is 07:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us