Printing with page breaks and filters prints blank pages

bruty

Active Member
Joined
Jul 25, 2007
Messages
445
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?
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Omer_K

Board Regular
Joined
Apr 9, 2017
Messages
73
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

Active Member
Joined
Jul 25, 2007
Messages
445
Hi Omer,

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

Watch MrExcel Video

Forum statistics

Threads
1,098,858
Messages
5,465,106
Members
406,412
Latest member
superjoejoe

This Week's Hot Topics

Top