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

Extract Numbers Using Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013.  Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column. One of the cool uses of Flash Fill is extracting the numbers from your text au...
Find & Replace The Find & Replace feature or CTRL+H shortcut allows you to amend your data in seconds.  Imagine you had thousands of rows of data that was downloaded from an external system with the wrong date.  A simple CTRL+H will save you heaps of time!  See how below. DOWNLOAD WORKBO...
Summarize Data With Dynamic Subtotals What does it do? It returns a Subtotal in a list or database Formula breakdown: =SUBTOTAL(function_num, ref1) What it means: =SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data) ***Go to the bottom...
Find Errors with Go to Special Constants Say you have a data set and want to make sure that each column contains what it is supposed to. For example, say you have a column which contains Dates and you want to check that there are no cells which contain Text. You can easily check this by highlighting that column an...