Locked Hidden rows, allow filter for a protected sheet

Jonny Grönhaug 96 Reputation points
2021-03-28T21:16:57.47+00:00

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?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,645 questions
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erin Ding-MSFT 4,456 Reputation points
    2021-03-29T09:44:57.187+00:00

    @Jonny Grönhaug

    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.

    0 comments