Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
How difficult is it to break Excel’s worksheet protection?
Easy, but you need to buy a program on the internet to do it
Extremely difficult, as Excel's protection is based on 128-bit encryption
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
Create another formula that reads =H22, and then hide row 22 and protect the worksheet
Modify the protection properties for H22 to Hide Formula, and then protect the worksheet
When it comes to security in Excel, by default all cells are...
Locked, but unprotected
Locked and hidden, but unprotected