Saturday, November 23, 2013

How to Use the AutoFill Function in Excel 2003


1. Open Excel.
2. Open your worksheet by clicking 'File > Open.'
3. If you don't have an existing worksheet, create a new one. Go to 'File > New.'
4. Enter your information. The AutoFill function will be able to fill in information in a series. When making a calendar, for example, you can type 'January' into the first box and use AutoFill to put the subsequent months in the next cells.
5. Place your mouse over the bottom right hand corner of the cell with 'January' (or whatever the first cell in your series is). When you see a small 'x' appear where your mouse arrow was, click and drag the 'x' to the cell where your series will end. The rest of the series should be filled in for you.

Blogger news