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.

If you've inserted manual pagebreaks, then excel will still respect them--even
if they're hidden.

I'd remove those manual page breaks.

You may want to save your file, remove the manual page breaks, print your
reports and close without saving. So you don't have to re-insert those breaks.

Syed Tabish Ghazi wrote:

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.

--

Dave Peterson