Protection and Data Validation in Excel

• Protecting Sheets
• Protecting Cells
• Adding Data Validation Rules

To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password.

A data-validation rule is a rule concerning what kind of data can be entered in a cell. When you select a cell that has been given a rule, an input message tells you what to enter, as shown here. And if you enter the data incorrectly, an error alert tells you as much, also shown. A data-validation rule in action.

Online training will be delivered via MS Teams. You will receive joining instructions before your selected session.