Search for courses or lessons
Redeem a coupon
Start free trial
How difficult is it to break Excel’s worksheet protection?
Extremely difficult, as Excel's protection is based on 128-bit encryption
Easy, but you need to buy a program on the internet to do it
Very easy! Step-by-step methods are freely available on the internet and can be used with very little prior knowledge
Suppose you want to hide the logic of the formula contained in cell H22. But you still need to show the workbook to other users. Which method is the best?
Change the font for H22 to the same color as the cell’s fill
Modify the protection properties for H22 to Hide Formula, and then protect the worksheet
Create another formula that reads =H22, and then hide row 22 and protect the worksheet
When it comes to security in Excel, by default all cells are...
Locked and hidden, but unprotected
Locked, but unprotected
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement