Excel worksheet not printing all rows

Occasional Visitor

I am trying to print a worksheet with 14 rows on one sheet. I only get 11 rows, with a lot of white space at the bottom. The additional rows don't print on the next page.

2 Replies


On the Page Layout tab of the ribbon, click the arrow in the lower right corner of the Page Setup group.

Activate the Sheet tab of the Page Setup dialog.

Has a range been entered in the Print Area box? If so, clear that box, then click OK.

@Hans Vogelaar this was very helpful and exactly what I needed to know