Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dale Fye
 
Posts: n/a
Default Auto Filter not working properly

I have a spreadsheet I received from a co-worker, about 250 rows by 10
columns. The first couple of columns have values in all cells, the last 6 or
eight are either blank or have an 'X' in the column to indicate that column
applies to the row. I'm trying to filter on the 'X' in several of the
columns, but Excel only seems to be recognizing about the first 6 rows,
because the auto filter does not show the X's if they don't show up in the
top 6 rows. I went to the advanced filter, and it has the top 6 rows
selected, and when I try to reset them to select all of the rows, it appears
to work, but when I go back to Data-Filter-Advanced, the same six rows show
up.

Any help would be greatly appreciated.
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Is there a blank row in the table at row seven? (It might be hidden.)
That could cause the problem that you described.

Dale Fye wrote:
I have a spreadsheet I received from a co-worker, about 250 rows by 10
columns. The first couple of columns have values in all cells, the last 6 or
eight are either blank or have an 'X' in the column to indicate that column
applies to the row. I'm trying to filter on the 'X' in several of the
columns, but Excel only seems to be recognizing about the first 6 rows,
because the auto filter does not show the X's if they don't show up in the
top 6 rows. I went to the advanced filter, and it has the top 6 rows
selected, and when I try to reset them to select all of the rows, it appears
to work, but when I go back to Data-Filter-Advanced, the same six rows show
up.

Any help would be greatly appreciated.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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
excel links update not working in auto, calculations in auto Mikey Boy Excel Worksheet Functions 0 December 8th 04 12:53 AM
auto filter question Juco Excel Worksheet Functions 0 November 29th 04 03:48 PM
auto filter question Juco Excel Worksheet Functions 1 November 28th 04 03:51 PM
The Auto Filter button lost the column specified option. D Excel Worksheet Functions 1 November 5th 04 12:47 AM
Why can't my macro use Auto Filter when I told the Sheet Protecti. KC Rippstein Excel Worksheet Functions 1 October 28th 04 06:13 PM


All times are GMT +1. The time now is 05:04 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"