Skip to main content Help with accessibility Skip to main navigation
Updated on: 20-05-2024

Excel - Protect Worksheets and Validate Data Input (Intermediate/Advanced)

Topics covered

Protection and Data Validation in Excel

  • Protecting Sheets
  • Protecting Cells
  • Adding Data Validation Rules including drop down lists

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.

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.

At the end of the session all delegates will:

On successful completion of this course you will be able to:

  • Protect worksheets and workbooks
  • Add Data Validation Rules to a worksheet

About the course

Course Code MLCSU-TR0034
Intended Audience Regular users of Excel or those who have completed Excel Introduction topics
Delivery Method Online
Required Experience / Training Comfortable with the content of the Excel Introduction topics Quiet room with access to MS Teams and headset or headphones
Duration of Training 1 hour