Excel shortcuts

A Shortcut to Locking Formulas in Excel

If you're like most Excel users, you probably spend a lot of time creating formulas. And if you're like most Excel users, you probably also spend a lot of time accidentally changing those formulas. Maybe you accidentally hit the delete key while trying to select a cell. Or maybe you accidentally dragged a cell that you didn't mean to. Either way, it's easy to accidentally change a formula, and it can be frustrating to have to go back and fix it. Fortunately, there's a shortcut that you can use to lock formulas in Excel. Here's how it works:

1. Select the cells that contain the formulas that you want to lock.

2. On the Home tab, in the Editing group, click Find & Select. Then click Go To.

3. In the Go To dialog box, click the Special button.

4. In the Go To Special dialog box, select the Formulas option. Then click OK.

5. On the Home tab, in the Editing group, click Find & Select. Then click Replace.

6. In the Find what box, type an equal sign (=).

7. In the Replace with box, type a single quotation mark (').

8. Click the Options button.

9. In the Search options dialog box, make sure that the Match entire cell contents check box is selected. Then click OK.

10. Click the Replace All button.

That's it! All of the formulas in the selected cells will now be locked. This shortcut works by adding a single quotation mark in front of the equal sign in each formula. This doesn't change the value of the formula, but it does prevent the formula from being accidentally changed. So next time you're working with formulas in Excel, try this shortcut to lock them down.

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.