Printing with page breaks and filters prints blank pages

[bruty]

I have a range of cells that need to be printed and different ranges are to be printed depending on a filter that has been applied. I have had to set up some manual page breaks to make sure the pages are printed correctly, but the problem I have is when the filters are on there are some blank pages printed due to the manual page breaks.

Is there any way to print this and make sure the blank pages are not printed?

 

[Omer_K]

Hey bruty,
Try this:
sign on of the cell in the range - then click on Ctrl + T to create a table,
Go To 'Page Layuot' - 'Set page layout'
make your manual page breaks then your filters,

let me know if it's work..

Omer.

 

[bruty]

Hi Omer,

Unfortunately I don't think this will work as the ranges I am trying to print includes graphs and images.