Here's how:. As an example, let's insert a footer that displays a page number and file name:. Voila, our Excel footer is created, and the following information will be printed at the bottom of each page:. Most of the preset headers and footers in Excel are entered as codes, which makes them dynamic - meaning your header or footer will change to reflect the latest changes you make to the worksheet.
To see the codes, just click the corresponding header or footer text box. If you have chosen to add a complex header or footer, chances are that different elements will be inserted in different boxes like in the above example:.
When adding a built-in header or footer, you cannot control the location of specific elements - they are inserted in the predefined boxes no matter which box left, center, or right is currently selected.
In Excel worksheets, not only can you add preset headers and footers, but also make your own ones with custom text and images. Then, click one of the boxes at the top header or at the bottom footer of the worksheet and type your text there. This example will show you how to create a custom header with your company logo, page numbers, file name and current date. Our custom Excel header looks pretty nice, don't you think?
If case you'd like to create a header or footer for chart sheets or for several worksheets at a time, the Page Setup dialog box is your option. To insert a preset one, click the drop-down arrow in the Header or Footer box and choose from the available options.
For example:. There are two ways to edit headers and footers in Excel - in Page Layout view and by using Page Setup dialog. Or, click the Page Layout button on the status bar in the bottom-right corner of the worksheet:. Another way to modify an Excel footer or header is by using the Page Setup dialog box. Please remember that a header and footer of chart sheets can only be edited in this way. Once you have finished creating or editing your Excel footer or header, how do you get out of the header and footer view and return to the regular view?
By doing any of the following:. Or, just click the Normal button on the status bar. To remove an individual header or footer, simply switch to Page Layout view , click the header or footer text box, and press the Delete or Backspace key. Now that you know the essentials of Excel headers and footers, the below tips may help you avoid common challenges.
To insert headers or footers on multiple worksheets at a time, select all target sheets, and then add a header or footer in the usual way.
When finished, right click any unselected sheet to ungroup the worksheets. If all of the sheets are selected, click any sheet tab, and then click Ungroup Sheets in the context menu.
To quickly change the font style or font color of your header or footer, select the text and pick the desired formatting option in the pop-up window:. If you'd like to insert a specific header or footer on the first page of your worksheet, you can have it done in this way:. To keep the font size of the header or footer text intact when the worksheet is scaled for printing, switch to Page Layout view , select the header or footer, go to the Design tab and clear the Scale with Document box.
If you leave this checkbox selected, the header and footer font will scale with the worksheet. For example, the header text will become smaller when you select the Fit Sheet on One Page printing option. That's how you add, change and remove headers and footers in Excel. I thank you for reading and hope to see you on our blog next week. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets. Click in the Left , Center , or Right section box, and then click any of the buttons to add the header or footer information that you want in that section.
To add or change the header or footer text, type additional text or edit the existing text in the Left , Center , or Right section box. Excel has many built-in text headers and footers that you can use.
For worksheets, you can work with headers and footers in Page Layout view. For chart sheets or charts you need to go through the Page Setup dialog. Click the left, center, or right header or the footer text box at the top or the bottom of the worksheet page.
Tip: Clicking any text box selects the header or footer and displays the Header and Footer Tools , adding the Design tab. Instead of picking a built-in header or footer, you can choose a built-in element. For chart sheets or charts, you can work with headers and footers in the Page Setup dialog. Click the left, center, or right header or footer text box at the top or the bottom of the worksheet page.
Use the buttons in the Header or Footer dialog box to insert specific header and footer elements. Tip: When you rest the mouse pointer on a button, a ScreenTip displays the name of the element that the button inserts. On the Design tab, in the Options group, check one or more of the following:. To remove headers and footers from the first printed page, select the Different First Page check box.
To specify whether the headers and footers should use the same font size and scaling as the worksheet, select the Scale with Document check box. To make the font size and scaling of the headers or footers independent of the worksheet scaling, which helps create a consistent display across multiple pages, clear this check box. To make sure the header or footer margin is aligned with the left and right margins of the worksheet, select the Align with Page Margins check box. To set the left and right margins of the headers and footers to a specific value that is independent of the left and right margins of the worksheet, clear this check box.
To remove headers and footers from the first printed page, select the Different first page check box. To specify whether the headers and footers should use the same font size and scaling as the worksheet, select the Scale with document check box. To make the font size and scaling of the headers or footers independent of the worksheet scaling, which helps create a consistent display across multiple pages, clear the Scale with Document check box.
To guarantee that the header or footer margin is aligned with the left and right margins of the worksheet, select the Align with page margins check box. Tip: To set the left and right margins of the headers and footers to a specific value that is independent of the left and right margins of the worksheet, clear this check box.
On the View tab, in the Workbook Views group, click Normal. You can also click Normal on the status bar. Note: If you want to delete headers and footers for several worksheets at once, select the worksheets, and then open the Page Setup dialog box.
You can always ask an expert in the Excel Tech Community or get support in the Answers community. Printing in Excel. Page Setup in Excel. Notes: To start a new line in a header or footer text box, press Enter. Click the worksheet where you want to add or change a built-in header or footer. Excel displays the worksheet in Page Layout view.
Click the worksheet to which you want to add specific header or footer elements. Add built-in header and footer elements for a chart sheet or chart. Click the chart sheet or chart where you want to add or change a header or footer element. Excel displays the Page Setup dialog box.
Click Custom Header or Custom Footer.
0コメント