How to Use the AutoFill Function in Excel 2003

The AutoFill function in Excel lets you save time by automatically filling in certain cells in your spreadsheet. For example, if you are creating a schedule, you can enter "Monday" and use AutoFill to complete the remainder of the days.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

• Computer with 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.

Tips & Warnings

• AutoFill can fill in dates, numbers and days of the week.
• If you go too far in the series, you can easily remedy the situation. Simply go back using the "Undo" button on toolbar, which looks like an arrow pointing to the left. Or just delete the overflow in the cells that you don’t need.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.