Question

Explain three different ways you protest your workbook.

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.

$<b>1. Locking cells$

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

$<b>2. Protecting Sheets$

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

$<b>3. Protecting an Entire Workbook$

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

✨We can set a workbook open password when saving a file. Use File ribbon tab > Save As and then click on the Tools button and choose General Options:

✨✨✨✨✨✨✨✨✨✨✨✨✨✨✨✨

HOPE IT HELPS YOU.