Locking a cell with $

1 / 5

Every price is multiplied by the same rate, in F1.

keyboard Typing formulas is easiest on a computer with a keyboard.

A1
ABCDEFG
1ItemPrice £Price €Rate1.12
2Monitor Stand40.49
3Headset46.25
4Office Chair51.49
5Bookshelf41.5
6USB-C Hub40.25
7
8
9
10
11
12
prices
in euros
rate
Type to enter a value or a formula starting with =. F2 edits, F4 adds $ to a reference.
Study notes

In a bit more detail

  • What happens to cell names when you copy?

    Excel moves every cell name with the formula. Usually that's what you want: B2 becomes B3, then B4.

  • How do you keep one cell fixed?

    When every row should use the same cell, like one exchange rate or one tax rate, put a $ before the column letter and the row number: $F$1. It then stays F1 wherever you copy the formula.

  • Is there a shortcut?

    While typing a cell name, press F4 to add the $ signs.

Know someone fighting with a spreadsheet? Send them this page.