Protecting excel worksheets

Protecting certain cells or outputs on a spreadsheet prevents other users from making changes to the sheet.  Ideally suited for spreadsheets that are sent out to multiple users to work on where any accidental changes would be seriously detrimental.  Protecting excel worksheets is a skill you must be familiar with.

Protecting a single excel sheet

We can protect a whole worksheet by right clicking on the tab you would like to protect.

Protecting excel worksheets

You are then presented with the following options

Excel protecting worksheets

Once protected the entire sheet cannot be amended by other users.