How to specify a fixed cell in a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Allen - 13 Jan 2006 00:33 GMT

Perhaps I am explaining myself in the wrong termonology but when I drag a
cell into multiple cells below it
the formula changes cells. How do I make it from changing cells.

--
Dave

Reply to this Message

Paul B - 13 Jan 2006 01:14 GMT

Dave, you need to use a absolute, or mixed reference, form excel help

Switch between relative, absolute, and mixed references
Select the cell that contains the formula.
In the formula bar , select the reference you want to change.
Press F4 to toggle through the combinations. The "Changes To" column
reflects how a reference type updates if a formula containing the reference
is copied two cells down and two cells to the right.

Formula being copied

Reference (Description) Changes to
$A$1 (absolute column and absolute row) $A$1
A$1 (relative column and absolute row) C$1
$A1 (absolute column and relative row) $A3
A1 (relative column and relative row) C3

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Perhaps I am explaining myself in the wrong termonology but when I drag a
> cell into multiple cells below it
> the formula changes cells. How do I make it from changing cells.
>
> --
> Dave

Reply to this Message