Protect cells but allow filter/ pivot table/ sort

Please purchase the course before starting the lesson.

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.

 

Lesson tags: vlookup
Back to: Advanced Excel Course > Protecting spreadsheet information and formulas