Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto filter on multiple rows
Is it possible to hav auto-filter on multiple rows, say, row 3 for one group
of data AND row 10 for another group of data? thank you !! jane |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto filter on multiple rows
You can filter on one range per worksheet. You can remove the filter and
reapply if you want. If you're using xl2003, you can try data|list. It looks quite similar to autofiltering. In xl2007, I think it's Data tab|Table (or something like that????). ==== As a general rule, if those two tables show different stuff, I'd use different worksheets for each. It'll make life much easier if you want to insert/delete columns or do any other processing with those ranges of data. Jane wrote: Is it possible to hav auto-filter on multiple rows, say, row 3 for one group of data AND row 10 for another group of data? thank you !! jane -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
Hidden Rows with Auto-Filter | Excel Worksheet Functions | |||
Why don't all my data rows show up in auto-filter? | Excel Worksheet Functions | |||
Auto Filter out text or blank rows | Excel Discussion (Misc queries) | |||
Auto Filter Multiple Selections | Excel Discussion (Misc queries) |