How to delete Page breaks in Excel - Microsoft Excel 2010

when you open a new page in word or excell, in the menu bar across the top there will be examples of page set up
click on the one you want and it should give what you want

To remove the header or footer text from Excel 2010 worksheet, you can follow the instructions below:
1.Go to "Insert" tab and then go to "Text" section.
2.Click "Header and Footer"
3.Click the left, center, or right header or footer text box at the top or the bottom of your worksheet page.
(Note: Clicking any text box selects the header or footer and displays the "Header and Footer Tools", adding the "Design" tab.)
4.Press "Backspace" or "Delete" on your keyboard.
To know more about removing header and footer, you can refer to "Remove the header or footer text from a worksheet" section on the following Microsoft support page:
http://office.microsoft.com/en-in/excel-help/use-headers-and-footers-in-worksheet-printouts-HP010342991.aspx#BMremoveheaderfootertext

Hope this will help you.

GuruAid.com

Don't put anything in blank pages, not even a space, now select the pages those you want to print and print selection.
It must help you out

It will locate all error containing cells, now rectify the error save it reopen in excel to see if problem is solved.

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

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

You can delete a blank page in a Word document by deleting the page break at the end of the page. You can also combine two pages by deleting the page break between them.
Make sure you're in normal view (on the View menu, click Normal). If nonprinting characters, such as paragraph markers , are not visible, click Show/Hide on the Standard toolbar, and then do one of the following:

• 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.
• To delete a page break placed before a specific paragraph, click the paragraph, and then on the Format menu, click Paragraph, click the Line and Page Breaks tab, and then clear the Page break before check box.

Excel 2010

Under the View tab, switch from Page Break to Normal. Or, use the Zoom if already on normal view.

Page breaks are are generally supplied by the controlling application, for example, Word, Excel.

For Excel, apart from using the "File" > "Page Setup" to define the page, you also have to define the "Print Area".

What is the application you are using to create the report?

Don

When you say prepare . .
What data is going in - and what needs to come out ?

At the moment - it looks like you just need standard coloumn control...
From the standard input columns do you need to break the data down into specifics (Ie time frames etc...which will incorporate cumulatives..)
I would personally suggest using MS Access - you will have greater control and GUI to minimize accidental deletion etc..