Keep Selected Cell/Row Visible After Changing Filter

[mjones]

Hi All,

Trying to find a row in an 8000-row spreadsheet, I filter to find what I need in row 6690.

Great. Select the first cell in that row.

Now I need more rows under this row, so I change the filter to open those rows too.

And voila, I see rows 742 to 762.

Prior to refiltering, I needed to memorize row number 6692 so I can now scroll way down to find it again. It’s annoying when one needs to do this hundreds of times.

Is there a way to keep my selected row 6690 visible after changing filtered rows? Maybe not, but then again, people on this board have come up with amazing ideas, so I ask.

Thanks again!

Michele

 

[mjones]

Actually, I figured out that if the row you want to be on after un-filtering is the top row, it will stay at the top and not get lost hundreds or thousands or rows down. So the trick is to have the row at the top (of the visible rows).