Auto fill Excel function’s: (Lesson 20 ) :

Posted by on
As we discussed before in lesson 8 we can auto fill cells with data by click and drag cells .  we also can auto fill functions by the same way click  and drag 

we will take a very simple example to illustrate this lesson .the figure below show us sequence in column A from cell  A1 to A10





in cell B1  we will write a formula which is
=a1 


Then we will drag like we did before from the black cross at the right bottom of cell the figure below show the result


after we drag the function The formula will be copied to the selected cells but there number of row changing in the dragging process ,when we copy formula to cell b2 the no. Of row changing in the formula to be 2
we used trace formula to illustrate the result 






Comments

Post a Comment