Modifying Headers and Footers
Headers and footers can be extremely useful tools for organizing and identifying a document. After you have created a header or footer, Excel allows you to customize the header and footer information for a given worksheet. This document describes some options for modifying your headers and footers.
Adjusting Margins
You may want to check your custom header or footer to ensure that it will print properly. If there are problems with the display of your header or footer, you may be able to fix them by adjusting the margins. You can adjust the margins in two ways: using the mouse option or the dialog box option.Adjusting Margins: With the Mouse
- From the Office Button menu
, select Print » Print Preview
Your document is displayed in Print Preview mode. - In the Preview group, select Show Margins
The margin outlines appear. - Using the mouse, click and drag the margin outlines to the desired position
NOTE: The uppermost and bottommost margins are for the header and footer, respectively. - Click CLOSE PRINT PREVIEW
Excel returns to the work area.
Adjusting Margins: With the Page Setup Dialog Box
- From the Office Button menu
, select Print » Print Preview
Your document is displayed in Print Preview mode. - In the Print group, click PAGE SETUP
The Page Setup dialog box appears. - Select the Margins tab
The Page Setup dialog box refreshes to display the Margins options. - In the Top, Left, Right, Bottom, Header, and/or Footer text boxes, type the preferred margin size
OR
Use the nudge buttons to adjust the margins - Click OK
The Page Setup dialog box closes. - Click CLOSE PRINT PREVIEW
Excel returns to the work area.
Setting a Custom Page Number
By default, page numbering starts with one. However, Excel allows you to begin numbering the first page with a number other than one.- Add your header or footer
- From the Ribbon, select the Page Layout command tab
- In the Page Setup group, click PAGE SETUP
The Page Setup dialog box appears. - Select the Page tab
The Page Setup dialog box refreshes to display the Page options. - In the First page number text box, type the number that will begin the page numbering
- Click OK
The Page Setup dialog box closes.
Make sure to let me know in the comments below or on our Facebook page how you've got with it or Do you have any questions
No comments:
Post a Comment