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
 
Top