How can I return to the row I left off on after filtering?

[Greg]

I am working with a database with lots of information. I am using filtering
to find certain groups. When I filter and then turn off filtering, it
returns me to the top of spreadsheet: I would like to return automatically
to the row I left off on.

 

[YESHWANT]

Hi Greg,

it's very simple. while filtering is still on, place the cursor on the row
you want to view after removing the filter, remover the filter by pressing
date - filter - autofilter and before clicking or pressing any other key,
just press left or right arrow key and you will be on that row.

click yes below, if it works