Search for courses or lessons
Redeem a coupon
Start free trial
How difficult is it to break Excel’s worksheet protection?
Extremely difficult as it is based on 128bit encryption
Easy, you just have to buy a program on the internet to do it
Super easy. There are free step by step methods published on the internet to do so
If you wanted to hide the logic in the formula in H22, but still need to show the workbook to someone, how would you best do this?
Change the font on cell H22 to the same color as the cell’s fill
Create another formula that reads =H22, then hide row 22 and protect the worksheet
Modify the protection properties on H22 to Hide Formula, then protect the worksheet
By default, all Excel cells are:
Locked and hidden, but unprotected
Locked, but unprotected
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement