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.