#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default autofiltering

when using autofilter for a certain item in a column containing 80+ rows, the
filter stops at a blank row (row 15) and you can see the remaining rows below
that haven't been filtered.

appreciate any and all assistance
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default autofiltering

Remove autofilter, then re-select the entire col(s), re-apply autofilter.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bernie R" wrote:
when using autofilter for a certain item in a column containing 80+ rows, the
filter stops at a blank row (row 15) and you can see the remaining rows below
that haven't been filtered.

appreciate any and all assistance

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
Autofiltering Thapelo Excel Worksheet Functions 3 November 5th 07 06:44 AM
AutoFiltering Mennochio Excel Discussion (Misc queries) 1 September 15th 06 08:08 PM
autofiltering Reggiee Excel Discussion (Misc queries) 2 August 2nd 06 04:32 PM
How to speed up Autofiltering? Dmitry Kopnichev Excel Worksheet Functions 13 March 1st 06 11:40 AM
Autofiltering [email protected] Excel Discussion (Misc queries) 2 October 4th 05 02:44 PM


All times are GMT +1. The time now is 01:31 PM.

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

About Us

"It's about Microsoft Excel"