# Excel Basics: AutoFill Formulas

Did you want Working with Numbers: 2007,2010,2013,2016  or español

Formulas use numbers from other cells on the sheet, or even from other sheets or other workbooks to do calculations. You can use AutoFill when you have to create a set of similar formulas. What a time saver!

Excel is really, really smart when it comes to formulas. But don't let Excel out-smart you! When you copy a formula into another cell, Excel will modify the formula. If you copied into the next cell down the column, for example, all the cell references in the formula are changed down one cell.

What does this look like? Suppose you have in cell G3 the formula = A3*B3/D4. If you copy the formula down one cell into G4, Excel changes the formula to =A4*B4/D5. All the cell references are changed down one, so that they are in the same relative location, compared to the cell with the formula.

For more on formulas, read the extra material in the Appendix and do the review exercises.

Where you are:
JegsWorks > Lessons > Numbers

Project 3: Format & Arrange

Project 4: Groups & Formulas

Project 5: Design

Search
Glossary
Appendix

## Step-by-Step: AutoFill Formulas

 What you will learn: to create a simple formula to AutoFill a formula down a column

When a trip is sold at World Travel Inc., the Total Sale is calculated by multiplying the number people going on the trip by the cost per person. You will create the formula that calculates this. Then you will copy the formula to other Total Sale cells.

Start with: trips5.xls (saved in previous lesson)

### Formula: Enter

1. Select cell E5.

2. Type = , then click on cell C5.
3. Type an asterisk * (the one on the keypad is easier) and click on cell D5.
4. Press ENTER. The value is calculated and is shown in the cell E5. In the Formula bar you see the formula used.

If you forget to press ENTER, your mouse clicks will continue trying to put cell references in the Formula Bar. This creates quite a mess!

### AutoFill: Formula

1. With cell E5 still selected, drag the fill handle down to copy the formula into cells E6:E23.

2. Click on each cell in the range E6:E23 and check the formula in the formula bar.

AutoFill changed the formula for each cell. This only works when the values used in the calculations are neatly arranged in rows and columns. It pays to be neat!

3. Save As  trips6.xls .
How to handle a full disk

If you find some of your numbers look like ######, the column is just not wide enough to show all the digits in the numbers. Simply make the column wider.