ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Filters (https://www.excelbanter.com/excel-discussion-misc-queries/96297-excel-filters.html)

Shaun

Excel Filters
 
i am using excel 2003. when i bring up a sheet that already has filters on it
and using the dropdown select (ALL) it seems to filter certain rows in my
sheet. the rows all have data in each cell the same as all the other rows. i
thought that when you selected (ALL) it showed every line without filtering.

baxybaxy

Excel Filters
 

shaun

it should do. if you have loads of data, it just seems to bomb
sometimes (memory?). i have this issue all the time and unfortunately
have no fix for it


--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=556078


CLR

Excel Filters
 
Only if that were the only column being filtered. To clear the entire
Autofilter, just do Data Filter AutoFilter.......it toggles it off and on.

Vaya con Dios,
Chuck, CABGx3



"Shaun" wrote:

i am using excel 2003. when i bring up a sheet that already has filters on it
and using the dropdown select (ALL) it seems to filter certain rows in my
sheet. the rows all have data in each cell the same as all the other rows. i
thought that when you selected (ALL) it showed every line without filtering.



All times are GMT +1. The time now is 02:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com