simple but can't make it, delete blank pages?!?!

[cat3appr]

Hello all!

Please see the attached .xls file, I need to get rid of the extra blan
pages where there is only the vertical page break... when I go on prin
preview I get 4 pages but I just need the 2 pages where there is th
actual data... I know it appears trivial but I didn't manage to find
solution.

Please help!
Thank you

+-------------------------------------------------------------------
|Filename: test.xlsx.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=930
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Sun, 10 Nov 2013 22:54:14 +0000 schrieb cat3appr:

Please see the attached .xls file, I need to get rid of the extra blank
pages where there is only the vertical page break... when I go on print
preview I get 4 pages but I just need the 2 pages where there is the
actual data... I know it appears trivial but I didn't manage to find a
solution.

Set on Ribbon Page Layout => Print Area the Print Area to the expected
range.
Then View => Page Break Preview and drag the page breaks to the wished
position.


Regards
Claus B.