Monday 17 October 2011

How to use Autofill funtion in excel!

Once you have written down the formula it's quite a hassle to write it again for other cells especially when the formula is quite tedious. Lucky for us excel autofill function allow the same formula to be copied form 1 cell to the cells you want to formula to be copied to.
once you have written down the formula go to the cell and select it. placing your marker on the bottom right of the cell will make a cross appear. Drag the cross down to the row you want your formula to be copied to and excel will copy the formula to all other rows ... hence saving a lot of time.

1 comment:

  1. Very informative and impressive post you have written, this is quite interesting and i have went through it completely, an upgraded information is shared, keep sharing such valuable information. Read more: How to Autofill in Excel

    ReplyDelete