Using Filters in Excel 2000
You get one range to filter per worksheet. That range can have multiple
columns, though.
xl2003 added a Data|List feature that looks a lot like data|filter|autofilter.
And you can have multiple lists per worksheet in xl2003+.
chris menzies wrote:
Hi All
I have an Excel 2000 workbook and I would like to have 2 Filters on the same
worksheet. Is this possible? When I highlight my selection and choose
Filter, it will just remove one filter and create a new one, thus not
allowing me to have the 2 on the same page.
I would be interested if this is just an Excel 2000 issue and whether later
versions (or though I dont own any!!!) allow you this option.
Thanks
--
Dave Peterson
|