How to Lock and Hide Formula in Excel
Вставка
- Опубліковано 11 вер 2024
- How to lock and hide formulas at once in Excel: msexceltutoria...
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/excelco...
Excel VBA Programming Course: bit.ly/excelvba...
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutoria...
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@...
Quora: bit.ly/3bxB8JG
Thanks a lot
Happy to help
Thank you very much for this video. It was so timely and on point.
You are most welcome
brilliant thnx a lot
So nice of you
explained well, thanks
Glad you liked it
So helpful, thank you!
Glad it was helpful!
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?
thanks
You're welcome! Please subscribe and share
Thanks you
Welcome. Please subscribe and share
nice
Thanks
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
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.
Thank you
You're welcome!