software

Let's say I have a long formula I don't want to rewrite on each cell.
I want to paste it to other cells but also the formula should change to
reflect its new location.

Heres the formula:
=(B3=quot;mildquot;)*1 (B3=quot;moderatequot;)*2 (B3=quot;mod-severequot;)*3 (B3=quot;severequot;)*4 (B3=quot;intolerablequot;)*5

The above formula is in C3 referring to B3.

I want to paste it down starting in C4 but how will the fomula
automatically change from B3 to B4, B5, B6.....without typing it
manually?

Thanks.--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile: www.excelforum.com/member.php...oamp;userid=27027
View this thread: www.excelforum.com/showthread...hreadid=514167The easy way is to grab the fill handle (lower right corner of source cell)
and drag down.

--
Don Guillett
SalesAid Software

quot;cardingtrquot; gt; wrote
in message ...
gt;
gt; Let's say I have a long formula I don't want to rewrite on each cell.
gt; I want to paste it to other cells but also the formula should change to
gt; reflect its new location.
gt;
gt; Heres the formula:
gt; =(B3=quot;mildquot;)*1 (B3=quot;moderatequot;)*2 (B3=quot;mod-severequot;)*3 (B3=quot;severequot;)*4 (B3=quot;intolerablequot;)*5
gt;
gt; The above formula is in C3 referring to B3.
gt;
gt; I want to paste it down starting in C4 but how will the fomula
gt; automatically change from B3 to B4, B5, B6.....without typing it
gt; manually?
gt;
gt; Thanks.
gt;
gt;
gt; --
gt; cardingtr
gt; ------------------------------------------------------------------------
gt; cardingtr's Profile:
gt; www.excelforum.com/member.php...oamp;userid=27027
gt; View this thread: www.excelforum.com/showthread...hreadid=514167
gt;
Hi,
another way is single click on C3, then while holding down the Shift
key single click on the lowest column C cell that you want to have your
formula, then press Ctrl the d key to fill down your formula.
If Don's way did not work then the quot;Allow cell drag and dropquot; option is
probably unchecked. Toolsgt;Optionsgt;Edit then click on quot;Allow cell drag
and dropquot; will turn it back on.
Another shortcut is to double click the fill handle. Excel detects the
values in column B and fills your formula down as far as the column B
values.

Ken JohnsonOr you can select the cells in the address box C3:C200
before using Ctrl D with the formula in C3.More on use of fill handle and similar mouse and keyboard shortcuts.
www.mvps.org/dmcritchie/excel/fillhand.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Ken Johnsonquot; gt; wrote ...
gt; Hi,
gt; another way is single click on C3, then while holding down the Shift
gt; key single click on the lowest column C cell that you want to have your
gt; formula, then press Ctrl the d key to fill down your formula.
gt; If Don's way did not work then the quot;Allow cell drag and dropquot; option is
gt; probably unchecked. Toolsgt;Optionsgt;Edit then click on quot;Allow cell drag
gt; and dropquot; will turn it back on.
gt; Another shortcut is to double click the fill handle. Excel detects the
gt; values in column B and fills your formula down as far as the column B
gt; values.
gt;
gt; Ken Johnson
gt;