This feature enables you to eliminate a last page that has only a few records or to expand data over more pages than it really requires.

Occasionally, you might end up with just a few rows printing on the last page.

Thats not exactly a problem, but those two or three additional rows printed on the last sheet can look unprofessional.

In addition, it seems wasteful in todays greener environments.

Simply use Excels Scale To Fit option to reduce the number of pages needed.

For instance, if a report is five pages, but page five has only two rows of data, this option would reduce the number of pages to four.

In Excel 2007, click the Page Layout tab and open the Scale To Fit group.

Thats the compromise -- the option changes the text size just a bit.

In most situations, where youre pulling only a few records onto the previous page, no one will notice the change.

However, if you have conventions that dont allow for subtle changes, you wont want to use the Scale To Fit option.

How Do I Get Rid Of The Last Blank Page In Excel 16 L Manual Page Breaks

In addition, Excel will ignore manual page breaks when you apply this option.

For instance, if you have four pages of data and you want to fill six, youd follow the instructions above but enter 6 in the Tall control.

Excel wont increase the font size, but it will divide the data over six pages.

How Do I Get Rid Of The Last Blank Page In Excel For Mac 16 L