Excel for Human Resource and Payroll Personnel

Protect cells but allow filter/ pivot table/ sort

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.

 

0 of 137 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop