Password Protection - Locked cells

Hi
In Excel if we lock the sheet, then we are not able to use the filter option. is there any solution for the same??

Fasial

You can check the box that says "use auto filter" below the password entry field when you protect the sheet. That sohuld allow users to use the auto filter even when password protected.