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: [ Ссылка ]
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
[ Ссылка ]
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
[ Ссылка ]
Here goes the most recent video of the channel:
[ Ссылка ]
Playlists:
Advance Excel Tutorial: [ Ссылка ]
Excel Tutorial for Beginners: [ Ссылка ]
Excel Case: [ Ссылка ]
Combine Workbook & Worksheets: [ Ссылка ]
All About Comments in Excel: [ Ссылка ]
Excel VBA Programming Course: [ Ссылка ]
Social media:
Facebook: [ Ссылка ]
Twitter: [ Ссылка ]
Blogger: [ Ссылка ]
Tumblr: [ Ссылка ]
Instagram: [ Ссылка ]
Hubpages: [ Ссылка ]
Quora: [ Ссылка ]
How to Hide Formula In Excel
Теги
Excel 10 Tutorialexcel tutorialexceltutorialmicrosoft excelexcel 2019excel tricksexcel tipse10tmsexceltutorial.comHow to Hide Formula In Excelhide formula in excel without protecting sheethow to hide formula in excel but allow inputhow to hide formulas in excel until data enteredhide formula in excelhow to hide formula in excelhide formulaFormulaFunctionShowHide