Remove a Page Break in Excel An Excel page break problem can also create unexpected dotted lines. When you have a spreadsheet formatted to print, page breaks are represented horizontally by lines.

Launch Microsoft Excel 2010 and open the spreadsheet you want to edit. Select the worksheet for which you want to insert the page number. Click the "View" tab on the upper side of the Excel window.