Microsoft Office Tutorials and References
In Depth Information
Adding a Header and Footer, Changing the Margins, and Printing the Workbook
Click the Insert tab
on the Ribbon, click
the Shapes button
on the Ribbon, and
then click the Arrow
button in the Shapes
gallery (column 3,
row 1).
Point immediately
to the right of the
letter t in Profi t in
the text box, and
then drag the arrow
to the center of
the brace to draw
the arrow.
arrow shape added
to chart and color
Click the Subtle
Line - Dark 1 shape
style in the Shape
Styles group to select
it and change the
color of the brace.
Click outside the
chart area to dese-
lect the chart
(Figure 6–65).
Click the Company
tab and then select cell A14 to deselect the chart range.
Figure 6–65
Click the Save button on the Quick Access Toolbar to save the workbook.
Adding a Header and Footer, Changing the
Margins, and Printing the Workbook
A header is printed at the top of every page in a printout. A footer is printed at the bottom
of every page in a printout. By default, both the header and footer are blank. You can change
either so that information, such as the workbook author, date, page number, or tab name,
prints at the top or bottom of each page.
Sometimes, you will want to change the margins to increase or decrease the white
space surrounding the printed worksheet or chart. The default margins in Excel for both
portrait and landscape orientation are set to the following: Top = .75 inch; Bottom = .75
inch; Left = .7 inch; Right = .7 inch. The header and footer are set at .3 inch from the top
and bottom, respectively. You also can center a printout horizontally and vertically.
Changing the header and footer and changing the margins are all part of page
setup , which defi nes the appearance and format of a printed worksheet. To change page
setup characteristics, select the desired sheet(s) and then click the Page Layout tab on
Search JabSto ::

Custom Search