i am working in a single worksheet that contains 7 columns and 1000 rows. and
i apply autofilter on each columns. the question is that whenever i select a
value from the filter and take a print privew of those filtered rows so it
previws the filtered rows in multiple pages whereas the rows that i filtered
could be on a single page.
I need to have them on a single paper.