Sunday, July 23, 2017

Scale a worksheet

Scale a worksheet

If your worksheet has a lot of columns, you can use the Scale to Fit options to reduce the size of the worksheet to better fit the printed page.

How

  1. Click the Page Layout tab on the ribbon.

  2. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page.

    Scale to Fit

    To print your worksheet on just one page, in the Height box, select 1 page. That said, if you do this, however, the resulting printout may be hard to read, because Excel shrinks the data to fit. To see how much scaling is used, look at the number in the Scale box. If it's a low number, you may need to make other adjustments before you print. For example, you may need to change the page orientation from portrait to landscape or target a larger paper size. For more information, see the section below to understand a few things about scaling a worksheet to fit a printed page.

  3. To print your worksheet, press CTRL+P to open the Print dialog box, and then click OK.

Things to know about scaling a worksheet

For an optimal experience when scaling worksheets, it is important to remember a few things.

  • If your worksheet has a lot of columns, you may need to switch the page orientation from portrait to landscape. To do this, go to Page Layout > Page Setup > Orientation, and click Landscape.

  • Consider using a larger paper size to accommodate a lot of printed columns. To switch the default paper size, go to Page Layout > Page Setup > Size, and then choose the size you want.

  • Use the Print Area command (Page Setup group) to exclude any columns or rows that don't need to be printed. For example, if you want to print columns A through F, but not columns G through Z, set the print area to include only columns A through F.

  • You can shrink or enlarge a worksheet for a better fit on printed pages. To do that, in Page Setup, click the Dialog Box Launcher. Then, under Scaling, click Adjust to, and then enter the percentage of the normal size that you want to use.

    Note: To reduce a worksheet to fit the printed pages, enter a percentage that is smaller than 100%. To enlarge a worksheet to fit the printed pages, enter a percentage greater than 100%.

  • Page Layout view isn't compatible with the Freeze Panes command. If you don't want to unfreeze the rows or columns in your worksheet, you can skip Page Layout view and instead use the Fit to options on the Page tab in the Page Setup dialog box. To do that, go to Page Layout tab, and in the Page Setup group, click the Dialog Box Launcher Button image at the bottom-right side. Alternatively, press ALT+P, S, P.

  • To print a worksheet on a specific number of pages, in Page Setup, click the Dialog Box Launcher. Then, under Scaling, in both the Fit to boxes, enter the number of pages (wide and tall) on which you want to print the worksheet data.

    Notes: 

    • Excel ignores manual page breaks when you use the Fit to option.

    • Excel does not stretch the data to fill the pages.

  • To remove a scaling option, go to File > Print > Settings > No Scaling.

When you print an Excel worksheet, if the printed font size is not what you expected, you can scale the worksheet for print by increasing or decreasing its font size.

  1. In the worksheet, click File > Print.

  2. Under Settings, click Custom Scaling > Custom Scaling Options.

  3. Click Page and in the Adjust to box, pick a percentage by which you want to increase or decrease the font size.

  4. Review your changes in Print Preview and if you want a different font size, repeat the steps.

    Note: Before you click Print, check the paper size setting in the printer properties, and also make sure the printer actually has paper of that size. If the paper size setting is different from the paper size in your printer, Excel adjusts the printout to fit the paper size in the printer and the printed worksheet might not match your Print Preview.

    In Print Preview, if the worksheet appears compacted to a single page, check if a scaling option like Fit Sheet on One Page is applied. Refer to the previous section for information.

See Also

Quick start: Print a worksheet

No comments:

Post a Comment