Microsoft Office Tutorials and References
In Depth Information
To Add a Header and Footer, Change Margins, and Center the Printout Horizontally
6
Click anywhere on the worksheet
to deselect the page footer.
Next Page
button
Previous Page
button
Click the Normal view button on
the status bar and then select cell
A14. Click the Page Layout tab
on the Ribbon and then click the
Page Setup Dialog Box Launcher
on the Ribbon to display the Page
Setup dialog box.
Close Print
Preview button
page header
top margin set
at 1.5”
Click the Print Preview button
in the Page Setup dialog box
to preview the Company sheet
(Figure 6–71).
7
Click the Next Page button and
Previous Page button on the Print
Preview tab on the Ribbon to
preview the other pages.
left and right margins
set at .5”
After previewing the printout,
click the Close Print Preview
button on the Ribbon.
page 1 of 4
page footer
Figure 6–71
To Add a Header to the Clustered Cone Chart Sheet
The following steps add the same header applied to the four worksheets in the
previous steps to the Clustered Cone Chart sheet.
1 Click the Clustered Cone Chart tab and then on the Page Layout tab, click the Page Setup
Dialog Box Launcher.
2 When Excel displays the Page Setup dialog box, click the Header/Footer tab, click the
Custom Header button, and in the left header box type J. Quasney (or your name if
you are stepping through the chapter on a computer). Press the ENTER key and then type
Profi t Potential to complete the entry.
3 In the center header box, type &[Tab] to instruct Excel to print the sheet name in the
Center Header section.
4 In the right header box, type &[Date], &[Time] to instruct Excel to print the sheet name
in the Right Header section.
5 Click the OK button in the Header dialog box and then click the OK button in the Page
Setup dialog box.
6 Click the Company tab. Click the Save button on the Quick Access Toolbar to save the
workbook.
 
 
Search JabSto ::




Custom Search