Headers and footers in a worksheet

     
Excel for autotruyenky.vn 365 Excel 2021 Excel 2019 Excel năm 2016 Excel 2013 Excel 2010 Excel 2007 Excel Starter 2010 More...Less

You can add headers or footers at the top or bottom of a printed worksheet in Excel. For example, you might create a footer that has page numbers, the date, & the name of your tệp tin. You can create your own, or use many built-in headers and footers.

Bạn đang xem: Headers and footers in a worksheet

Headers & footers are displayed only in Page Layout view, Print Preview, & on printed pages. You can also use the Page Setup dialog box if you want khổng lồ insert headers or footers for more than one worksheet at a time. For other sheet types, such as chart sheets, or charts, you can insert headers & footers only by using the Page Setup dialog box.

Add or change headers or footers in Page Layout view

Cliông chồng the worksheet where you want lớn add or change headers or footers.

On the Insert tab, in the Text group, cliông chồng Header & Footer.

Excel displays the worksheet in Page Layout view.

To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer).

Type the new header or footer text.


Notes: 

To start a new line in a header or footer text box, press Enter.

To include a single ampersvà (&) in the text of a header or footer, use two ampersands. For example, khổng lồ include "Subcontractors và Services" in a header, type Subcontractors &và Services.

To close headers or footers, clichồng anywhere in the worksheet. To cchiến bại headers or footers without keeping the changes that you made, press Esc.


On the Page Layout tab, in the Page Setup group, cliông chồng the Dialog Box Launcher

*
.

*

Excel displays the Page Setup dialog box.

On the Header/Footer tab, click Custom Header or Custom Footer.

Click in the Left, Center, or Right section box, & then cliông chồng any of the buttons khổng lồ 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 khổng lồ go through the Page Setup dialog.

Click the worksheet where you want lớn add or change a built-in header or footer.

On the Insert tab, in the Text group, cliông chồng Header & Footer.

Excel displays the worksheet in Page Layout view.

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 và displays the Header và Footer Tools, adding the Design tab.


On the Design tab, in the Header & Footer group, cliông xã Header or Footer, and then click the built-in header or footer that you want.

*

Instead of picking a built-in header or footer, you can choose a built-in element. Many elements (such as Page Number, File Name, & Current Date) are found on the ribbon. For worksheets, you can work with headers & footers in Page Layout view. For chart sheets or charts, you can work with headers and footers in the Page Setup dialog.

Cliông chồng the worksheet khổng lồ which you want lớn add specific header or footer elements.

On the Insert tab, in the Text group, click Header và Footer.

Excel displays the worksheet in Page Layout view.

Clichồng the left, center, or right header or footer text box at the top or the bottom of the worksheet page.

Xem thêm: Top 11 Phần Mềm Ghi Chữ Lên Hình, 10+ Phần Mềm Viết Chữ Lên Ảnh Tốt Nhất Hiện Nay


Tip: Clicking any text box selects the header or footer và displays the Header and Footer Tools, adding the Design tab.


On the Design tab, in the Header & Footer Elements group, clichồng the elements that you want.

*

Click the chart sheet or chart where you want to add or change a header or footer element.

On the Insert tab, in the Text group, cliông chồng Header & Footer.

Excel displays the Page Setup dialog box.

Clichồng Custom Header or Custom Footer.

Use the buttons in the Header or Footer dialog box khổng lồ insert specific header & footer elements.


For worksheets, you can work with headers và footers in Page Layout view. For chart sheets or charts, you can work with headers và footers in the Page Setup dialog.

Cliông xã the worksheet where you want khổng lồ choose header và footer options.

On the Insert tab, in the Text group, click Header và Footer.

Excel displays the worksheet in Page Layout view.

Clichồng the left, center, or right header or footer text box at the top or the bottom of the worksheet page.


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 kiểm tra box.

To specify that the headers & footers on odd-numbered pages should differ from those on even-numbered pages, select the Different Odd và Even Pages kiểm tra box.

To specify whether the headers và footers should use the same phông form size and scaling as the worksheet, select the Scale with Document kiểm tra box.

To make the font form size & 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 và right margins of the worksheet, select the Align with Page Margins kiểm tra 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.


Cliông xã the chart sheet or chart where you want khổng lồ choose header or footer options.

On the Insert tab, in the Text group, cliông xã Header & Footer.

Excel displays the Page Setup dialog box.

Select one or more of the following:

*

To remove headers và footers from the first printed page, select the Different first page kiểm tra box.

To specify that the headers & footers on odd-numbered pages should differ from those on even-numbered pages, select the Different odd & even pages kiểm tra box.

To specify whether the headers and footers should use the same phông kích thước và scaling as the worksheet, select the Scale with document kiểm tra box.

To make the font kích thước & 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 kiểm tra box.

To guarantee that the header or footer margin is aligned with the left & right margins of the worksheet, select the Align with page margins check box.


Tip: To mix the left & right margins of the headers và footers to lớn a specific value that is independent of the left and right margins of the worksheet, clear this check box.