Tip 186 – Instantly Size an Excel Worksheet to Print on a Single Page

To ensure your worksheet will print on a single sheet of paper, choose Page Layout and open the Page Setup dialog by clicking the dialog launcher. Select the Page tab and select Fit to 1 page(s) wide by 1 tall to shrink the sheet when printing to fit on a single sheet of paper. Omit the width value to have it print one page tall but multiple pages wide and omit the height value to have it print one page wide and multiple pages tall.