OK, that's a workaround ;-)
But I think it will work fine.
Thank you!
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?
-
Jonny Grönhaug 96 Reputation points
2021-03-29T09:52:15.61+00:00
1 additional answer
Sort by: Most helpful
-
Erin Ding-MSFT 4,456 Reputation points
2021-03-29T09:44:57.187+00:00 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.
Here is a gif, you could refer to.
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.