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
worksheets.
To Add a Header and Footer, Change Margins, and Center the Printout Horizontally
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 Profi 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.
1
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
Box Launcher
four worksheets
selected
Figure 6–66
 
 
Search JabSto ::




Custom Search