Scaling Print In Excel Manual Page Breaks

Scaling Print In Excel Manual Page Breaks

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

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.

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 its a low number, you many 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.

To print your worksheet, press CTRL P (CMD P on a Mac) to open the Print dialog box, and then click OK.

Things to know about scaling a worksheet For optimal experience when scaling worksheets, it is important to remember a few things.

If your worksheet as a lot of columns, you may need to switch the page orientation from portrait to landscape.

Consider using a larger paper size to accommodate a lot printed columns.

To switch the default paper size, go to Paper 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 dont need to be printed.

For example, if you want to print columns A through F, but not columns G through Z, set the print are to include only columns A through F.

You can shrink or enlarge a worksheet for a better fit on printed pages.

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 englarge a worksheet to fit the printed pages, enter a percentage greater than 100.

Page Layout view isnt compatible with the Freeze Panes command.

If you dont 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 int he Page Setup group, click the Dialog Box Launcher at the bottom-right side.

To print a worksheet on a specific number or pages, in Page Setup, click the Dialog Box Launcher.

Then, under Scaling, in both of the Fit to boxes, enter the number of pages (wide and tall) on which you want to print the worksheet data.

Scaling Print In Excel For Mac