Page Break Preview In Excel Manual Page Breaks

Page breaks in a worksheet are contained in two separate IXlPageBreaks collections: one for the horizontal (row) page breaks and one for the vertical (column) page breaks.

To get access to these collections, use the IXlSheet.RowPageBreaks and IXlSheet.ColumnPageBreaks properties, respectively.

To add a new page break, use the IXlPageBreaks.Add method and pass an index of the row or column after which a page break should be inserted.

To remove a single page break from a worksheet, use the IXlPageBreaks.Remove or IXlPageBreaks.RemoveAt method.

To clear all page breaks at once, use the IXlPageBreaks.Clear method.

All trademarks or registered trademarks are property of their respective owners.

Page Break Preview 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.

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.

To do this, go to Page Layout Page Setup Orientation, and click Landscape.

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

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.

Page Break Preview In Excel For Mac