Applying a function to multiple cells automaically

  • Thread starter Thread starter Linz
  • Start date Start date
L

Linz

Quite a basic question that I'm sure there is an easy answer to.

Have a basic function (=D5*(1-E5) that shows a discounted value for an
amount in D5 by the percentage in E5.

How can I apply the same function to rows below without re-typing the
function for each line. ie. =D6*(1-E6) etc.
 
Here's one way:

Suppose cell G5 contains this formula: =D5*(1-E5)
Select cell G5
In the lower right hand corner of the selected cell you'll notice a little
black square. This is called the fill handle.
Hover the mouse over the fill handle. The cursor will change from a "fat" +
sign to a "skinny" + sign.
When the cursor changes to a skinny + sign left click and hold then drag
down the column as far as needed.
The formulas (and cell formats) will be copied with the references
incrementing as desired.
 
Worked great Biff. Thanks


T. Valko said:
Here's one way:

Suppose cell G5 contains this formula: =D5*(1-E5)
Select cell G5
In the lower right hand corner of the selected cell you'll notice a little
black square. This is called the fill handle.
Hover the mouse over the fill handle. The cursor will change from a "fat"
+ sign to a "skinny" + sign.
When the cursor changes to a skinny + sign left click and hold then drag
down the column as far as needed.
The formulas (and cell formats) will be copied with the references
incrementing as desired.
Click to expand...
 
You're welcome!

Here's another tip about using the fill handle...

This will only work for copying down a column, won't work for copying across
a row...

If there is data on either side of the selected cell and it's a contiguous
block, double clicking the fill handle will also copy down until it
encounters an empty cell where it will automatically stop.
 
Back
Top