Filtering Multiple Areas on a Single Sheet

  • Thread starter Thread starter KKD
  • Start date Start date
K

KKD

I have two areas on a single worksheet that I want to use filters on. Is it
possible to apply more than one row of filters?
 
Nope.

You get one area with autofilter on it per sheet.

But if you're using xl2003+, you could use multiple lists (data|List in xl2003
menus)

or in xl2007, you can use the Insert tab of the ribbon and then Tables group,
click the Table icon.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and paste area not same in filtered mode . 8
Using Filter more than once 2
Copy and pasting values of filtered rows 1
Are Date filters available for items in the Filter area of pivot t 2
Pivot Tables - Page Area 1
Can't Copy and Paste when I'm using a filter List.. hmmm 1
Auto Filter Single Column 2
PIVOT - Reference a cell outside the table for report filtering 2

Back
Top