Reply to Message

once again 2003 does it much quicker and simpler

One word of caution on using the Show All/Clear All Filters option: if you have a very wide and long spreadsheet, it can take ages as it resets every column even if not filtered. In such cases it's quicker to toggle the autofilter off and on again.