Question

Explain three different ways you protect your workbook...please guys!

Answer 1

First of all you have to make sure the right cells are locked and unlocked.

Then, for locking to take effect, you have to individually protect each sheet of your workbook that contains at least one locked cell.

Finally, to prevent users invalidating your spreadsheet, for instance by deleting or moving whole sheets, you need to protect the structure of the overall workbook.



Before you consider locking the cells in your worksheet, you have to ensure their design is correct. 



The dialog explains that locking has no effect until the sheet is protected using the Protect Sheet option on the Review ribbon tab.



We might also need to prevent people accessing a confidential spreadsheet at all