Excel shortcuts

3 steps to lock formulas in excel using the $ shortcut

If you've ever accidentally deleted a cell in Excel that contained a formula, you know how frustrating it can be. Even worse is when you accidentally delete part of a formula. All your hard work, gone in a flash. But there's a way to prevent this from happening: by locking the cells that contain your formulas. This way, even if you accidentally delete a cell or range of cells, your formulas will still be intact.

Here's how to do it:

  1. Select the cells that contain your formulas.
  2. Click the 'Home' tab.
  3. Click the 'Format' button.
  4. Click 'Format Cells'.
  5. Click the 'Protection' tab.
  6. Check the 'Locked' box.
  7. Click 'OK'.

Now, when you try to delete a cell that contains a locked formula, you'll get a warning message telling you that the cell is locked and the formula will not be deleted. You can still delete the cell if you want, but the formula will remain intact.

One more thing: you can also use the '$' shortcut to quickly lock a cell or range of cells. Just select the cells you want to lock, then press F4. This will add the '$' symbol to the cell references in the formula, locking the cells in place. For example, if you have a formula in cell A1 that references cell B1, and you press F4, the formula will change to =$A$1+$B$1. Now, no matter what you do, the formula will always reference cells A1 and B1.

Locking formulas is a quick and easy way to protect your work in Excel. Give it a try the next time you're working on a complex spreadsheet.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.