how do i print filtered rows in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

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

Similar Threads

VBA to Filter on variable column 5
hidden rows problem 7
Copy/paste data across filtered rows 1
How do I autosum a filtered column 1
Select rows which satisfy 2 criteria 16
Merged cells disturb autofilter indicator 2
need help on either doing a loop and counting specific values orusing subtotal function 2
Filter Customize date 3

Back
Top