close
I have several tables in the same tab. I would like to be able to apply
independent autofilters to each table and display filtered results for
several tables at once.
I tried to search online but didn't find any tips on how to do this. Is this
possible in Excel 2003?
Thanks in advance!
No, you can only have one set of autofilters active in one sheet at a
time. An alternative is to copy your tables into different worksheets,
then you can set up filters on each table independently.
Hope this helps.
Pete
全站熱搜
留言列表
