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

For chart sheets or charts you need to go through the Page Setup dialog.Ĭlick the worksheet where you want to add or change a built-in header or footer. For worksheets, you can work with headers and footers in Page Layout view. Excel has many built-in text headers and footers that you can use. 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. 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. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets.Įxcel displays the Page Setup dialog box. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. When multiple worksheets are selected, appears in the title bar at the top of the worksheet. Add or change headers or footers in the Page Setup dialog Click the worksheet or worksheets, chart sheet, or chart where you want to add or change headers or footers. To close headers or footers without keeping the changes that you made, press Esc. To close headers or footers, click anywhere in the worksheet. Notes: To start a new line in a header or footer text box, press Enter. 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. Excel displays the worksheet in Page Layout view.

You can also use the Page Setup dialog box if you want to insert headers or footers for more than one worksheet at a time.įor other sheet types, such as chart sheets, or charts, you can insert headers and footers only by using the Page Setup dialog box.Īdd or change headers or footers in Page Layout view Click the worksheet where you want to add or change headers or footers. Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages. You can create your own, or use many built-in headers and footers. For example, you might create a footer that has page numbers, the date, and the name of your file. Less You can add headers or footers at the top or bottom of a printed worksheet in Excel. Perfect place to initialize certain variables. By extending from this class and overriding these methods, we can write additional data to the PDF document when these events occur. In this tutorial we demonstrate how to add a header and footer in a PDF document using iText. In the bottom right corner you can find the current page number, followed by the total number of pages.

At the bottom of the page we can optionally include a copyright symbol followed by some text.

Add footer in excel 2016