If you have a workbook with lots of formulas and you want to protect those formulas from being amended by other people who share your workbook, then you can!

You need to follow these steps:

1. Press the Go To Special shortcut CTRL+G

2. Select the Constants box and press OK (this highlights all the non-formula cells)

3. Press CTRL+1 to bring up the Format Cells dialogue box

4. Select the Protection tab and Un-check the Locked box

5. In the menu ribbon go to Review > Protect Sheet > then enter your custom password (optional)

This will lock all the cells that are not constant, so all the formula cells šŸ™‚


Lock Formula Cells




If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Quick Access Toolbar The Quick Access Toolbar (QAT) is located at the top left hand corner of the ribbon and has the most commonly used commands, like the Save, Undo and Redo.Ā  The QAT is unique to each userĀ“s workbook settings. You can move the QAT below or above the ribbon by right clicking on t...
Autosum an Array of Data in Excel When you have an array of data in Excel with Totals at the bottom and to the right of the data, you can quickly fill inĀ the Totals with theĀ Autosum button. STEP 1: Highlight your data including the "Totals" row and column; STEP 2: Click the Autosum button (under the Home or...
Dynamic Data Validation List WhatĀ“s a dynamic data validation drop down list in Excel, you say? Well, as you add new data into your Excel Table, your drop down list automatically gets updated. That is a cool feature and it means that you do not need to update your data validation source reference each ...
Pivot Table Conditional Formatting Inserting a Pivot Table is very easy to do in Microsoft Excel: Inserting a Pivot Table Adding some Conditional Formats to the Pivot Table allows a user to highlight key data in a split second. See how easy it is to add some color to your analysis. DOWNLOAD WORKBOOK ...