AutoFilter & Hiden Rows

  • Thread starter Thread starter M.Siler
  • Start date Start date
M

M.Siler

I have applied an AutoFilter and then hiden a few rows. When I select the
items I want to see from the AutoFilter drop down the resulting rows
displayed contain what I had hidden. Is there a way to stop the AutoFilter
from unhiding hidden rows?

-Mark
 
I don't think so.

Maybe you could add another column and add some kind of formula that evaluates
to what you need to hide (or just put an X in that column manually). Then you
could filter that column to hide the X's and filter and then filter on the other
columns the way you want.
 
Back
Top