how to set page breaks in Excel 2010

1. Click where you want to start a new page.
2. On the Insert tab, in the Pages group, click Page Break. Answered Mar, 27 2011

Its in the in View Tab, in the "Workbook Views"

To return to Normal view after you finish working with the page breaks, on the View tab, in the Workbook Views group, click Normal.

After working with page breaks in Page Break Preview view, you may still see the page breaks in Normal view because page breaks have been turned on automatically. To turn them off, clear the Show page breaks check box in the Excel Options dialog box (File tab, Options, Advanced category, Display options for this worksheet section). Answered Apr, 05 2011

1. Select the existing sheet, the source sheet, that contains the settings you want to transfer.
2. Select the target sheet(s) — the sheets you want to update –  by pressing [Ctrl] and clicking each sheet tab.
3. Select Page Setup from the File menu and click OK.

More  blogs.msdn.com/b/excel/

Answered Aug, 17 2010