Hide Select rows permanentely for for users except admin

[sagar40]

Hi Team

I want to make one spreadsheet where I want to Hide few rows permanently to other users.

So if we have sheet with 10 rows, I want hide five rows permanently and 5 rows visible. also I want these five rows which are visible user can use filters.

Regards
Sagar

 

[Veritan]

Hi Sagar, this may be what you're looking for. First, hide the rows you want hidden permanently. Then, in the Review tab at the top of Excel, click the Protect Sheet button. Make sure that the Use AutoFilter check box is checked. Then put a password on your file. This should hide your rows permanently while allowing any user to filter the data. A person will have to enter the password in order to unlock the sheet.

Edit: After a little bit more testing, what I suggested above won't work if your hidden rows are part of your filter. So you'll need to make sure that you specifically put the filter on only rows that you want to be visible.