Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2007

Tip: Looking for answers? Try searching our database.

auto filter on multiple rows

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jane - 08 Jun 2007 17:36 GMT
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 - 08 Jun 2007 19:48 GMT
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.

> 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

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.