I have inherited a number of spreadsheets where the previous user closed rows by dragging the mouse up the table and collapsing them. I have found no way to open them except by looking for each line and opening them individually. This has become painful with 600+ row sheets where I have to scroll down and look for groups (and sometimes a single one) of rows to open...one row at a time.



Is there a shortcut or command to make these open? The hide/unhide option is not working in this instance.

Ctrl+A
Then put your arrow on the grid line under a row number
It changes to an double arrow
Double click
All rows should be visible now

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you - Thank you - Thank you!!!

You're welcome

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post