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 🙂

DOWNLOAD WORKBOOK

Lock Formula Cells

HELPFUL RESOURCE:

eu_logo_150

 

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Show Averages With an Excel Pivot Table A Pivot Table is the most powerful feature within Excel as it allows you to analyze your data in many different ways, all with a press of a button.The Summarize Values By option allows you to choose a type of calculation (Sum, Count, Average, Max, Min, Count Numbers Produ...
Fix Incorrect Formatting Using Flash Fill In Excel  Flash Fill in Excel is a new feature that was introduced in Excel 2013.  One of the cool uses of Flash Fill is to fix incorrect formatting in your text automatically.Ever had the scenario where your data is formatted differently?Example: First names starting wit...
Fix Excel Hyperlinks to a Named Range Hyperlinks in Excel must be one of the funkiest features that I love playing around with!They allow you to create interactive buttons within Excel (without the need to create a Macro) and you can make them take you to any cell or range within your Excel worksheet.One shor...
Autofill Formulas in an Excel Table One of the advantages of using an Excel Table is the ability to autofill a formula all the way down your data without having to copy and paste.When you write a formula anywhere in your Excel Table, it will automatically fill down and up within that column.As you add extra...