getting rid of blank pages on a worksheet

[CountryPenguin]

I have a workbook with 2 pages.

One my first sheet, which only has data on one page, shows that it is "1 of 3". So when I go to print the entire workbook, I get 2 blank pages.

I want the 2 sheets to print on one sheet which is currently not possible.

How do I get rid of/delete these blank pages?

Any and all help will be greatly appreciated!

Thank you

[TMS]

Hard to say without seeing the workbook. Could be that you have deleted (lots of) rows but Excel still considers the "last row" to be further down the sheet than you think/expect. Or you could have formula(e) that return blank and/or null values that cover more pages. Or it could be formatted cells ...

Like I said, hard to know.

[josephteh]

Select the Page Break Preview view under View > Page Break Preview or click on the icon circled in red below, to see what is included in the Print Area:

Page Break Preview View.png

[maniacb]

You can also set the print area, Page Layout->Print Area->Set Print Area