Quote:
Originally Posted by bnyamin
I'm sure ...
This was done(open 8 row) with the click of a mouse...
but ...
click mouse + ???
question is = ???
I should not open filter ; for look row 8 ...
|
I watched your YouTube video, and you are correct, this should happen:
- You filter a column by some field
- Hover pointer over line between a set of hidden rows
- Double-click the icon to open the hidden rows. The icon needs to be the type in the attached image.
I do not know why you are unable to achieve this - your video shows you doing the correct actions. Maybe the version of Excel you are using? Or, what OS are you using? Do you have all updates installed?
My question is, why do you need to do this? Because you hid the rows using filter, so why now do you need to see them? Why not change the filter to bring back the blanks? Then you can see them that way.