How to Hide Formula in Excel
Sometimes we don’t want anyone to see the formula we used in our workbook or worksheet. How can we hide it? Well, a long time ago we learned how to lock formula in excel: https://youtu.be/yQjosXMTJyI
But today we will only hide it. We don’t want to lock it. You can do both if you want. Just follow the procedure of this video and the video linked in the description and you’ll be able to lock and hide formula at once.
Now with out further ado lets follow the procedure below to hide formula so that no one can see.
Step 1: Select the Entire worksheet by pressing CTRL + A
Step 2: Under the Home Tab Click on “Format” and then “Format Cells”
Step 3: Go to Protection Tab and Uncheck “Locked”
Step 4: Now Select All the Cells with Formula
Step 5: Under the Home Tab Click on “Format” and then “Format Cells”
Step 6: Go to Protection Tab and Check Mark “Hidden”
Step 7: Click on the Review tab and click on “Protect Sheet”
Step 8: Setup Password and click OK
Done. Now no one can see your formula. You can Copy the formula but you can’t see it. This is amazing piece of work. Thanks for watching.
#Hide #Formula #Excel
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
https://www.patreon.com/excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Here goes the most recent video of the channel:
https://bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG *Become a member and enjoy exclusive perks while supporting the channel you love!*
https://www.youtube.com/@Excel10tutorial/join