We would appreciate if you share with us your Excel version as well so that we can give you a more specific solution to your issue. In the meanwhile, you can refer to the following steps to delete a manually-inserted page break in Excel 2007, Excel 2010, or Excel 2013:
(Important: You cannot delete page breaks that Excel has added automatically. Adding manual page breaks, changing the page orientation, or adjusting column widths and row heights may affect automatically-inserted page breaks.)
1. Select the worksheet that you want to modify.
2. Go to "View" tab, then go to "Workbook Views" section, and click "Page Break Preview".
(Note: You can also click "Page Break Preview " on the status bar)
(Important: If you get the "Welcome to Page Break Preview" dialog box, click "OK". To avoid seeing this dialog box every time you go to "Page Break Preview" view, select "Do not show this dialog again" check box and click "OK".)
3. Now do one of the following:
a) To delete a vertical page break, select the column to the right of the page break that you want to delete.
b) To delete a horizontal page break, select the row below the page break that you want to delete.
(Note: You cannot remove automatic page breaks)
4. Go to "Page Layout", then go to "Page Setup" section, and click "Breaks"
5. Click "Remove Page Breaks"
(Important: You can also remove a page break by dragging it outside of the page break preview area {to the left or right for vertical page breaks, or up or down for horizontal page breaks}. If you cannot drag page breaks, make sure that the drag-and-drop feature is enabled. To check the status of your drag-and-drop feature, click office button , click "Excel Options" tab, click "Advanced", go to "Editing Options" and make sure you have checked the "Enable fill handle and cell drag-and-drop" option.)
To refer to a pictorial explanation of the above steps, you can refer to "Delete a manually inserted page-break" section on the following Microsoft Support Page:
http://office.microsoft.com/en-in/excel-help/remove-a-page-break-HA102576899.aspx?CTT=1
GuruAid.com
To delete a page manually, select the page break at the end of the page, and then press DELETE.
To delete a blank page at the end of the document, select the page break or any paragraph markers at the end of the document, and then press DELETE.
185 views
Usually answered in minutes!
×