The lock ($)

Lock a cell so it doesn't change when you copy.

Remember that, when you copy, the addresses change by themselves? Most of the time that's great. But sometimes you want the calculation to use the same cell every time, like a rate that applies to everyone.

Module: First steps. Lesson 6 of 62.

• Previous lesson: Copying a formula down many rows
• Next lesson: Percentages without fear
• All lessons