Cách Thiết Lập Header And Footer Trong Bài Thi Mos Excel

     
Excel for gift4u.vn 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel Starter 2010 More...Less

You can add headers or footers at the vị trí cao nhất or bottom of a printed worksheet in Excel. For example, you might create a footer that has page numbers, the date, và the name of your file. You can create your own, or use many built-in headers và footers.

Bạn đang xem: Cách thiết lập header and footer trong bài thi mos excel

Headers và footers are displayed only in Page Layout view, Print Preview, and 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

Click the worksheet where you want to showroom or change headers or footers.

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

Excel displays the worksheet in Page Layout view.

To địa chỉ or edit a header or footer, click the left, center, or right header or footer text box at the đứng đầu 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 ampersand (&) in the text of a header or footer, use two ampersands. For example, to include "Subcontractors & Services" in a header, type Subcontractors && Services.

To close headers or footers, click anywhere in the worksheet. To close headers or footers without keeping the changes that you made, press Esc.


On the Page Layout tab, in the Page Setup group, click 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, and then click any of the buttons to địa chỉ cửa hàng the header or footer information that you want in that section.

To showroom 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 và 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 to địa chỉ or change a built-in header or footer.

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

Excel displays the worksheet in Page Layout view.

Click the left, center, or right header or the footer text box at the vị trí cao nhất 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, click Header or Footer, và 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, và Current Date) are found on the ribbon. For worksheets, you can work with headers và footers in Page Layout view. For chart sheets or charts, you can work with headers and footers in the Page Setup dialog.

Click the worksheet khổng lồ which you want to showroom 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.

Click the left, center, or right header or footer text box at the đứng đầu or the bottom of the worksheet page.

Xem thêm: Này Người Yêu Em Thương Mến Ơi, Vĩnh Biệt Màu Xanh


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


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

*

Click the chart sheet or chart where you want to địa chỉ or change a header or footer element.

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

Excel displays the Page Setup dialog box.

Click Custom Header or Custom Footer.

Use the buttons in the Header or Footer dialog box to lớn insert specific header & footer elements.


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

Click the worksheet where you want to choose header và footer options.

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

Excel displays the worksheet in Page Layout view.

Click 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 và footers from the first printed page, select the Different First Page kiểm tra box.

To specify that the headers và 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 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 kiểm tra 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 phối the left & right margins of the headers & footers lớn a specific value that is independent of the left and right margins of the worksheet, clear this check box.


Click the chart sheet or chart where you want to choose header or footer options.

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

Excel displays the Page Setup dialog box.

Select 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 that the headers and 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 & footers should use the same font kích thước and scaling as the worksheet, select the Scale with document check box.

To make the font form 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 kiểm tra box.

Xem thêm: Bản Mẫu Kế Hoạch Học Tập Du Học Tập Xin Học Bổng Trung Quốc Làm Nổi Bật Hồ Sơ


Tip: To mix the left và 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.