Jump to content

Change automatic page breaks


Recommended Posts

Change automatic page breaks

Excel's Page Break Preview feature lets you use the mouse to move, delete, and insert page breaks.

To access this feature from a Normal view, go to View | Page Break Preview, or click the Page Break Preview button from Print Preview. This displays an image of the worksheet's print area. Solid lines indicate manual page breaks set by the user; dashed lines indicate where Excel will break the page automatically.

You can move page breaks, either automatic or manual, by clicking and dragging the break to a new location (left, right, up, or down). For example, clicking and dragging the right vertical page break on the first page to the right of the first column of the second page will move the column to the first page. Microsoft Excel automatically scales the worksheet to fit the new column to the page.

Click a page break and drag it outside the print area to delete it. To insert a new page break, right-click a row below or column to the right of the break, and select Insert Page Break.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...