You can specify exactly how many pages you want Excel to use when printing out your data. Excel will resize your worksheet to fit the number of pages that you specify.

This feature can be especially useful when your last page of data has just a few lines.

When using this feature, Excel ignores any page breaks that you have inserted.

This feature only affects printed output. It does not affect how your worksheet appears on the screen. Use Print Preview to see how your printout will look.