Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Greg" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell to return a specific value if left blank | Excel Worksheet Functions | |||
Losing count on bottom left hand side when filtering - HELP!!! | Excel Discussion (Misc queries) | |||
lookup value and return result in column to left | Excel Worksheet Functions | |||
filtering columns-left nav | Charts and Charting in Excel | |||
return left most part of cell | Excel Worksheet Functions |