If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Focing a cell to be used
Is it possible to keep a cell used when you drag an equation to multiple cells?
1200*a1^(b1) 1200*a2^(b1) .. .. .. 1200*an^(b1) the way it stand now, draging the equation leads to both cells roaming. I want to fix one cell. The question is how. |
#2
|
|||
|
|||
Focing a cell to be used
Use an absolute reference. Where you now have b1, use $b$1.
(There are also mixed references. $b1 would keep the column fixed as you copy across; b$1 would keep the row fixed as you copy down). "NAUBryan" wrote: Is it possible to keep a cell used when you drag an equation to multiple cells? 1200*a1^(b1) 1200*a2^(b1) . . . 1200*an^(b1) the way it stand now, draging the equation leads to both cells roaming. I want to fix one cell. The question is how. |
Thread Tools | |
Display Modes | |
|
|