Autofilter unhides rows in excel

[mrtauntaun]

I have several rows hidden in a spreadsheet. I want to use the autofilter on the displayed data only, however wheneven I make a selection with the filter, it unhides all hidden rows. Is there anyway to keep the hidden rows hidden? Doing so in VBA would be ideal, but i'll take anything at this point.

 

[firefytr]

Doesn't work that way. You would need a seperate column that says whether the row should be hidden or not (probably labeled "Hidden" with values of TRUE or FALSE, maybe 1 and 0, or 1 and "" {blank}, something to identify it), then filter additionally on that column.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci