Making protected Excel Spreadsheets easier to use

Protect cells but allow filter/ pivot table/ sort

This is a preview lesson
Register or sign in to take this lesson.
Note: All Excel protection is relatively weak. It is useful to stop casual users but it is not for top secret information.

If you need to protect a sheet (stop people changing inputs and formula) but you want to allow them to continue to use the Sort, Filter and Pivot Table options, you need to use different settings. For the most part these options don’t affect the numbers but it would be difficult for a user to work with the data if they can’t use these tools on a protected sheet.

To follow along go to 19.4

In order to allow the use of sorting, filtering and pivot tables on a  protected sheet you will need to tick some/ all of the options highlighted below.

Protect cells but allow filter pivot table sort