Cart 0

How to Use Excel’s Fit To Feature

Posted by Roger Hyttinen on

How many times have you gone to print an Excel spreadsheet only to discover that a couple of column were cut off or one or two rows printed on a separate page? Though you can reduce the font size to try to make everything fit, there’s a better way: Excel fit to feature. What this does is allows you to specify that you want to print your document on a fixed number of pages. For example, if you have a spreadsheet with a couple of rows showing up on the second page, you can choose to fit the entire spreadsheet on one page. Excel will shrink the spreadsheet to fit on one page.

To Use Excel’s Fit To feature:

  1. Click the Page Layout tab on the Ribbon.
  2. Click the Dialog Launcher on the Page Setup group of the Ribbon. 
Page Setup dialog launcher
  3. If necessary, click the Page tab.
  4. Under the Scaling area, click the Fit to radio button.
  5. Enter the number of pages wide (this is normally 1) and the number of pages tall you would like like your worksheet to print.
  6. To verify your settings, click the Print Preview button on the bottom of the Page Setup dialog box.

Looking for more Excel tips? Check out our new book Excel 2016:Up To Speed available as an ebook on Amazon, Kobo, and Apple iBooks

Share this post

← Older Post Newer Post →

Leave a comment

Please note, comments must be approved before they are published.