SOLVED

Excel worksheet not printing all rows

Copper Contributor

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.

4 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@bchlapek56 

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

This saved me as well. Thanks!

@pshawsappi 

Happy to hear that it helped!

1 best response

Accepted Solutions
best response confirmed by Sergei Baklan (MVP)
Solution

@bchlapek56 

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.

View solution in original post