Multiple Use Of Auto Filter

P

paulmoles

Is it possible in Excel Xp to use Auto Filter more than
once on ONE worksheet?
I have a worksheet containing several named ranges and
wish to AutoFilter each range separately.

I do not want to use seperate sheets as the combined
information is then difficult to see. (The Ranges are not
formula linked.).
Many Thanks
Paul Moles
 
D

Debra Dalgleish

No, you can only have one AutoFilter per worksheet. Perhaps you could
store the data on separate sheets, then open another window in the
workbook (Window>New), and tile the windows (Window>Arrange) to see both
 

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

Using Autofilter More Than Once 3
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
How do I auto-filter multiple ranges on one worksheet? 3
How to get range names to Apply across multiple tabs 1
Auto Populating & Name Recognition between Worksheets 1
sumif with multiple critera range and sum_range 5
named range in sum formula (indirect, offset, worksheet name) 4
Question on Named range with formula 2

Top