Excel insert, move and remove page break - modify page breaks

Here are simple steps on how to insert, remove and modify page breaks in Excel 2007 and 2010.

How to move and modify page breaks in Excel

  1. Go to view tab and click on preview page break preview.
  2. In the opening view you can drag the page (solid line = manual break, dotted line = automatic break) breaks where you wish.
Excel insert, move and remove page break - modify page breaks


How To add page breaks in Excel
  1. Click on the row / column on which you wish to add the page break
  2. Go to Page layout tab and from the page setup group  click breaks and select insert page break.
Excel insert, move and remove page break - modify page breaks

How to remove page breaks in Excel

  1. Click on the row / column of which you wish to remove the page break from (Note: you cannot delete automatic page breaks, only manual page breaks).
  2. Go to Page layout tab and from the page setup group  click breaks and select remove page break.

No comments:

Post a Comment