• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to protected the sheets without affecting the filter on sorting?

Dear Expert,

Good day.

I would like to ask on the excel spreadsheet that uploaded.

How can I protect the sheet without affecting the filter button as I have tried on Format Cells to lock it but it is affecting the filter button?

You may click the Unprotect Sheet by using the password 123.

I would accept any good idea on the excel method.