top of page
  • Excel Master

How To Lock Formulas in Excel In 3 Simple Steps Using The $ Shortcut

Here's how to lock formulas in Excel using the $ shortcut in 3 simple steps:

  1. Enter your formula normally in the cell where you want it.

  2. Place your cursor inside the formula where you want to lock the reference(s).

  3. Press the F4 key on your keyboard. This will add the $ symbol to the reference(s) to lock them in place.

Alternatively, you can manually type the $ symbol before the column and/or row reference in your formula to lock them. For example, if your formula references cell B2 and you want to lock that reference, you can change it to $B$2.

By locking formulas with the $ shortcut or manually adding $ symbols, you can prevent them from changing when you copy or move the formula to other cells. This is particularly useful when you have a formula that you want to use repeatedly without having to manually adjust the cell references each time.

51 views0 comments

Recent Posts

See All

How to Use the Autofit Column Width Shortcut in Excel

To use the Autofit Column Width shortcut in Excel, follow these steps: Open Microsoft Excel and navigate to the worksheet containing the columns you want to autofit. Select the column or columns that

How to Add Axis Labels in Excel

To add axis labels in Excel, follow these steps: Open Microsoft Excel and open the worksheet containing the chart you want to edit. Click on the chart to select it. This will activate the Chart Tools


bottom of page