Can insert footer in excel

With the Select All Sheets function in Excel, you can first select all sheets in current workbook and then insert header and footer to these selected worksheets.

Please do as follows. Right click on a worksheet tab in the Sheet Tab bar, and then click Select All Sheets in the right-clicking menu. See screenshot:. After selected all sheets, please click the Page Layout button on the Status Bar. Now the worksheets are displayed in the Page Layout view. In the Header section, click the header box and enter the header information as you like. Shift the worksheet to the normal view by clicking the Normal button on the Status Bar.

Right click on a sheet tab in the Sheet Tabs bar and then click Ungroup Sheets from the right-clicking menu. Before applying Kutools for Excel , please download and install it firstly. And finally click the OK button. Notes : There are several header options and footer options in the Page setup box, please check the corresponding ones based on the created header and footer in the specified sheet. Now the header and footer in the specified sheet are applied to all sheets within current workbook.

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. Header and footer in Excel: how to insert, edit and remove by Svetlana Cheusheva updated on March 3, This will switch the worksheet to Page Layout view.

Now, you can type text, insert a picture, add a preset header or specific elements in any of the three Header boxes at the top of the page. By default, the central box is selected: If you wish the header to appear in the top left or top right corner of the page, click the left or right box and enter some information there. When finished, click anywhere in the worksheet to leave the header area.

To exit the header box without keeping the changes, press Esc. When you print out your worksheet, the header will be repeated on each page.

On the Design tab, click Go to Footer or scroll down to the footer boxes at the bottom of the page. Depending on the desired location, click the left, center, or right footer box, and type some text or insert the element you want.

To add a preset footer , please follow these steps , to make a custom Excel footer , see these guidelines. When done, click anywhere in the worksheet to exit the footer area. 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.