LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daved
 
Posts: n/a
Default Excel filter dropdown shows all data

In the past, if I filtered a column, then clicked the arrow on the next
column, the dropdown box would only show me the data that had been filtered.
Now it seems to show ALL data. For instance, if I custom-filter to show data
that includes "whole," then click again on that column's filter arrow, the
dropdown list will still show all data, not just those that include "whole."

Similarly, filtering to "whole" then clicking on an adjacent column's filter
arrow will produce a box that shows everything. What's going on?
 
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
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 Rich Rodberg Links and Linking in Excel 1 October 21st 05 07:53 AM
Is there an easy way to filter duplicate rows of data in excel? Yumin Excel Discussion (Misc queries) 1 October 7th 05 08:15 PM
I've put data to columns - counted - need dropdown filter vic 2005 Excel Discussion (Misc queries) 0 September 1st 05 12:31 PM
Query Wizard - Filter Data - Dropdown missing? jameshalligan Excel Discussion (Misc queries) 0 July 26th 05 11:21 AM
Linking the data from one excel to another mrbalaje Excel Discussion (Misc queries) 2 June 13th 05 10:44 AM


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