Microsoft Excel:  Fit Your Spreadsheet to a Page

When working in Microsoft Excel, there are times when you have a spreadsheet that prints on one page except for a few rows or maybe a column or two. Instead of playing with the font size and/or the column width and row height, use the Fit to option to make the spreadsheet fit on a specific number of pages.

1. To do so, go to the File menu and select Page Setup...
2. Click on the Page tab. In the Scaling area, select the Fit to: option.
3. Use the spinner arrows to select the number of pages wide by the number of pages tall.
4. Click OK when finished.

When you look at the document in Print Preview, you'll see that the spreadsheet has shrunk just enough to allow the orphaned rows or columns to fit on the number of pages specified.

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.