Excel 2003

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 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 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.