Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 331
Default How can I return to the row I left off on after filtering?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 41
Default How can I return to the row I left off on after filtering?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell to return a specific value if left blank Sdtex Excel Worksheet Functions 6 May 15th 09 06:30 PM
Losing count on bottom left hand side when filtering - HELP!!! Elaine Excel Discussion (Misc queries) 3 July 14th 06 01:50 PM
lookup value and return result in column to left Mark M Excel Worksheet Functions 3 April 23rd 06 07:47 PM
filtering columns-left nav agrillo Charts and Charting in Excel 0 December 1st 05 08:40 PM
return left most part of cell Pat Excel Worksheet Functions 5 September 9th 05 04:34 PM


All times are GMT +1. The time now is 09:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"