| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering Multiple Areas on a Single Sheet
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? -- KKD |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtering Multiple Areas on a Single Sheet
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. KKD wrote: 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? -- KKD -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
| How do I set up a single header for a multiple sheet workbook? | Excel Discussion (Misc queries) | |||
| Printing multiple worksheet areas in a single page | Excel Worksheet Functions | |||
| Multiple sheets as data for a single sheet | Excel Worksheet Functions | |||
| Multiple Print areas in same sheet? | Excel Discussion (Misc queries) | |||
Linear Mode
