Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
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