Microsoft Office Tutorials and References
In Depth Information
To Add a Header and Footer, Change Margins, and Center the Printout Horizontally
the Ribbon. Remember to select all the sheets you want to modify before you change the
headers, footers, or margins, because the page setup characteristics will change only for
selected sheets. The headers and footers for chart sheets must be assigned separately from
As you modify the page setup, remember that Excel does not copy page setup characteristics when one sheet
is copied to another. Thus, even if you assigned page setup characteristics to the template before copying it to the
NextDVR Proﬁ t Potential workbook, the page setup characteristics would not copy to the new sheet. The following
steps use the Page Setup dialog box to change the headers, footers and margins and center the printout horizontally.
• With the Company sheet active,
scroll to the top of the document.
Page Layout tab
• While holding down the SHIFT key,
click the Portland sheet tab to
select the four worksheet tabs.
• Click the Page Layout tab on the
Ribbon (Figure 6–66).
Page Setup Dialog