Posted to microsoft.public.excel.misc

abcdbaker

Posts: n/a

I want to copy a formula down several rows and lock a cell ref.

How do I lock a cell reference in the formula that I'm dragging to other rows.

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
Cell References When Inserting Rows	officeplus215	Excel Discussion (Misc queries)	2	October 1st 05 02:00 AM
How to protect a cell or rows with MS excel 2000	jack	New Users to Excel	2	April 29th 05 05:15 AM
Lock Rows	Anthony	Excel Discussion (Misc queries)	2	March 3rd 05 03:55 PM
HELP! How do you--> Lock a set of rows but also link worksheets to	FRUSTRATED	Excel Discussion (Misc queries)	6	December 29th 04 10:05 PM
The $ thing to lock cells at rows or columns	[email protected]	Excel Discussion (Misc queries)	2	December 27th 04 11:57 AM

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

About Us

"It's about Microsoft Excel"