Excel XP

Inserting and Removing a Page Break

There are two different kinds of page breaks in Excel: soft page breaks and hard page breaks. A soft page break is automatically inserted into a spreadsheet when there is 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 needs to be inserted. This row will be the first row on the new page.
• Choose Insert Page Break from the menu bar.
  
  
  
  
• 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 Insert Remove Page Break from the menu bar.
  
  
  
  
• The page break (represented by a dashed line) is removed from the page.