May 20 2021 06:42 AM - edited May 20 2021 06:46 AM
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.
May 20 2021 07:01 AM
SolutionOn 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.
Oct 11 2022 08:31 AM
@HansVogelaar this was very helpful and exactly what I needed to know
Sep 13 2023 10:12 AM
Happy to hear that it helped!
May 20 2021 07:01 AM
SolutionOn 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.