How to Protect Cells that Contain Formulas in Excel

In my experience, many Excel users get frustrated and confused when they try to protect the worksheet cells that contain formulas. In this tutorial, I walk you through the three steps in the process.

We want to allow a user to enter and edit numeric values in some cells, while preventing any changes to the cells that contain formulas.

The key concept to understand: By default, all cells in an Excel Worksheet are "Locked." So, we need to select the input cells first and then "Unlock" them before protecting the worksheet.

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to preview all of the resources that I offer.

Danny Rocks
The Company Rocks

• Category

  Education

[Michal Turala]

Thank you - have been struggling with that all day:) (greetings from London)

[Danny Rocks]

Hello Michal -

Thanks for adding your comment. I am pleased that I could help you to "stop struggling" as a result of my Excel Tutorial.

Greeting back to you from California!

Danny Rocks

The Company Rocks

[Roy Brazil]

Crystal clear! Thanks.

[Danny Rocks]

Thank you Roy!

I am pleased that you enjoyed my Excel Tutorial.

Danny Rocks

The Company Rocks

[qassim abbas]

I congratulate you on your ability to give very clear instructions to solve complicated prblems. you're a legendary tutor. big thanks to you from Iraq.

[Danny Rocks]

Hello Qassin -

Thank you for your very kind words. I strive to be the best teacher that I can possibly be.

I appreciate you taking the time to add your comments.

Danny Rocks

The Company Rocks

[pow1983]

Brilliant tutorial helped a lot!!! I know a bit more about Excel.

[Ermin Jusufi]

Thanks a lot it was very helpful for me. You are doing a good job :D

[Danny Rocks]

Hi Tara -

Thank you so much for your very kind comments about my video tutorial! I greatly appreciate your feedback.

My philosophy is, "I work had to make it easy for my viewers and clients to lean how to get the most out of MS Excel."

Once again, thank you for adding your feedback.

Danny Rocks

The Company Rocks