Mixed references

In this lesson

1. 1. Lock only one part

   This table grows each sales amount by each rate.

   You can lock only the column or only the row. These are mixed references.

   $A3 locks column A. B$2 locks row 2.

2. 2. Copy across

   When you copy right, column A stays fixed. The rate column moves.

3. 3. Copy down

   When you copy down, row 2 stays fixed. The sales row moves.

4. 4. Read the formula

   One formula filled the whole table. Each cell still points to the right numbers.

5. 5. Switch with one key

   Press F4 (Mac: F4 or Cmd+T) again and again on an address. It changes like this:

   F1, then $F$1, then F$1, then $F1, then back to F1.

6. 6. Try it yourself

   Fill the costs table below in the same way.

Part of Excel Essentials. Short lessons with practice in a real spreadsheet, checked as you go.