Leading the way in Microsoft Office Development

Excel

Adding and Removing Page Breaks

It is possible to insert both Horizontal as well as Vertical page breaks.

To add a Horizontal page break, select the row below the row you want as the last row on the page

To remove a horizontal page break move the mouse over a cell directly below the page break line and select (Insert > Remove Page Break)

To remove a vertical page break move the mouse over a cell in the column directly to the right of the page break line and select (Insert > Remove Page Break).

To remove all the page breaks, select the whole worksheet and select (Insert > Remove Page Break).

To remove a page break. Select the row directly below or the column directly to the right of the page break.

There is also some additional commands on the Cell shortcut menu when you are in Page Break Preview.

Insert Page Break - Inserts a manual page break above the selected row to the left of the selected column.

Remove Page Break - Only appears when you select a cell (or range) that is below or to the left of a page break (excluding the outside border).

Reset All Page Breaks - Removes any manual page breaks.

Set Print Area - Same as (File > Print Area > Set Print Area)

Reset Print Area - Same as (File > Print Area > Clear Print Area)

Page Setup -

Manual Page Breaks

Any manual page breaks stay fixed when you make changes to the Page Setup, Page tab, Adjust to %

Changes to fit to - temporarily removes any manual page breaks (although switching back to "Adjust to" brings them back again).

Unless you are using "Fit to" you should consciously remove all the manual page breaks.

Automatic Page Breaks

An automatic page break is displayed as a dashed line with short dashes.

Manual page breaks remain active until you remove the,

To define a manual page break select (Insert > Page Break) - indicates by a dashed line ??

The Remove Page Break option only appears on the Insert menu when the cell pointer is in exactly the right place

where???

Things to Remember

To define the page setup on multiple worksheets, group them first.