Multiple Auto Filters ?

S

Steve Klenner

Is it possible to have 2 autofilters for 2 different ranges in a single
worksheet?

Autofilter #1 = Rows 1-100
Autofilter #2 = Rows 300-500

If it can...how do you do it?.......it seems like when I create the 2nd one
the first one becomes disabled.

Steve
 
D

Debra Dalgleish

You can only have one AutoFilter per worksheet.

Steve said:
Is it possible to have 2 autofilters for 2 different ranges in a single
worksheet?

Autofilter #1 = Rows 1-100
Autofilter #2 = Rows 300-500

If it can...how do you do it?.......it seems like when I create the 2nd one
the first one becomes disabled.

Steve
 

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

Top