question

JonnyGrnhaug-7127 avatar image
0 Votes"
JonnyGrnhaug-7127 asked JonnyGrnhaug-7127 answered

Locked Hidden rows, allow filter for a protected sheet

I’ve a protected sheet and allow filtering. I’ve also have som hidden rows and the user should not have the possibility to see this rows. Everything is fine until i make some filtering and then show all rows, then all rows will be visable. Even the hidden rows. How do I solve that?

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JonnyGrnhaug-7127 avatar image
0 Votes"
JonnyGrnhaug-7127 answered

OK, that's a workaround ;-)
But I think it will work fine.
Thank you!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

erinding-msft avatar image
0 Votes"
erinding-msft answered erinding-msft edited

@JonnyGrnhaug-7127

Based on your description, I did a test and reproduced your issue.

As a workaround, you could try to right-click the rows you would like to hide, then set the Row Height to be 0.1 to check this issue.
82391-image.png

Here is a gif, you could refer to.
82401-test.gif


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


image.png (2.5 KiB)
test.gif (359.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.