Tip of the week : Absolute Cell Address

Often, when you need to copy a formula down, it must reference one particular cell.  That’s when you put in the dollar sign in the formula, ie you make the cell Absolute.  This is a definite must to ensure that when copying, this cell stays constant.

absolute-cell-address

If you look at the formula above, when copying the formula down, E6 must become E7, which becomes E8 etc.  That is a relative cell address.  But B3 must stay B3.   To ensure that, click in the Formula Bar next to the cell you wish to make Absolute (in this case, cell B3).  Press F4, which will add the dollar signs, making the cell Absolute.  In the above example, B3 is the cell which must stay constant.  So it should read – $B$3.  Now when you copy for the formula down, all formulas will stay constant  and ALL will multiply by B3.

“Watch this space for the next exciting tip.  OR you can beat the rest by contacting us on 011 802 1636 and book your space on our professional training”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s