How to Lock and Hide Formula in Excel

How to lock and hide formulas at once in Excel: msexceltutorial.com/post/How-...
In this intermediate Excel tutorial, I’ll demonstrate how you can lock and hide formulas in Excel but allow input. In a previous tutorial, I’ve explained the process of locking formulas in Excel; you can check that here: • How To Lock And Protec...
I've also explained how to hide formulas in excel; here is it: • How to Hide Formula In...
In this tutorial we are going to combine those procedures at once. It means we are going to do a few things at once here.
1. Lock formulas in Excel
2. Hide formulas in Excel
3. Allow the user to input data into the rest of the cells.
Now let’s follow the procedure below to lock and hide the formula in Excel without protecting the entire sheet.
Step 1: Select the entire worksheet
Step 2: Click on "Format" and then "Format Cells" under the Home Tab
Step 3: Go to the "Protection Tab" from the popup menu and uncheck "Locked" and "Hidden"
Step 4: Now Select the Cells with Formula
Step 5: Click on "Format" and then "Format Cells" Under the Home Tab
Step 6: Go to the Protection Tab and check both "Locked" and "Hidden"
Step 7: Click on the Review tab and click on "Protect Sheet"
Step 8: Setup Password and click OK
Done! No one can now view, edit, or delete your excel formula. If you need to edit or delete the cells with a formula, you’ll need to enter the password. Thanks a million for watching. If you need to lock cells in Microsoft Excel, you can check out this tutorial: • How To Lock Cells in M...
#Lock #Hide #Formula
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Here goes the most recent video of the channel:
bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG

[@virsanjay]

explained well, thanks

[@Excel10tutorial]

Glad you liked it

[@user-gh2vs9ik1i]

Thank you very much for this video. It was so timely and on point.

[@Excel10tutorial]

You are most welcome

[@rebeccabowerman8716]

So helpful, thank you!

[@Excel10tutorial]

Glad it was helpful!

[@MoneySteps]

Great info. But once the sheet is protected by password, the workbook too.
Would it possible to protect the sheet formula, but available users to access workbook without password?

[@BanglaIslamicQuestionAnswer]

thanks

[@Excel10tutorial]

You're welcome! Please subscribe and share

[@shoptika4373]

Thanks you

[@Excel10tutorial]

Welcome. Please subscribe and share

[@md.shafiqurrahman5721]

nice

[@Excel10tutorial]

Thanks

[@godwinuche4669]

You are too fast in showing what you click. When you selected the whole worksheet just notice how you quickly select format cell without anyone even noticing it. Try to slow down please. Anyone who’s watching some of these videos to learn is not an expert like you.
Also try to zoom your videos so it can be easy and more interesting for us to continue coming back to this channel. Thank you for your adjustment on these points I raise

[@Excel10tutorial]

Thanks a million for your advice. I'm working on these points. I do have several video scheduled already. But soon you'll see some of this improvements. For the time being please check the description. I've written the step by step instruction there. Thanks again for your concern. Hope you'll stay with us.

[@saquibsher]

Thank you

[@Excel10tutorial]

You're welcome!