Print Management

Printing in Excel XP can sometimes be complicated. Learn about Excel XP printing, including setting the right print area, in this lesson.

Inserting and removing a page break

There are two types of page breaks in Excel: soft page breaks and hard page breaks. A soft page break is automatically inserted into a spreadsheet when there's too much data to fit on one page. A hard page break is one that you can insert into a spreadhseet, wherever you want it to appear.

To insert a page break:

  • Move the cursor to the row where a page break should be inserted. This row will be the first row on the new page.
  • Choose InsertPage Break from the menu bar.

    Insert and Page Break Menu Options
  • A page break, indicated by a dashed line, is inserted into the worksheet.

To delete a page break:

  • Move the cursor to the row where a page break appears.
  • Choose InsertRemove Page Break from the menu bar.

    Insert and Remove Page Break Menu Options
  • The page break, represented by a dashed line, is removed from the page.