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

[Falinaicare]

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.

Thanks.

 

[rahulshewale1]

hi @Falinaicare ,

See if is it ok ?

Go to protect Sheet > Check Use AutoFilter option

 

[Falinaicare]

hi rahulshewale1,

Many thanks. It is working... finally.

 

[rahulshewale1]

Welcome