When finished, click anywhere in the worksheet to leave the header area.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. 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.This will switch the worksheet to Page Layout view. Go to the Insert tab > Text group and click the Header & Footer button.Inserting a header in an Excel worksheet is quite easy. How to remove header and footer in Excel.How to change header and footer in Excel.In the normal worksheet view, they are not visible. Headers and footers are displayed only on printed pages, in Print Preview and Page Layout view. Microsoft Excel provides a handful of predefined headers and footers to choose from, as well as allows creating your own ones.

Generally, headers and footers contain basic information about the spreadsheet such as page number, current date, workbook name, file path, etc. To make your printed Excel documents look more stylish and professional, you can include a header or footer on each page of your worksheet. Remember that the field braces must be inserted in pairs using Ctrl+F9, not simply typed.Do you want to know how to make a header in Excel? Or are you wondering how to add the footer page 1 to the current worksheet? This tutorial will teach you how to quickly insert one of the predefined headers and footers and how to create a custom one with your own text and graphics. If you did that, press Alt+F9 again to toggle back to displaying field results rather than codes.

If you press Alt+F9 you should see something like the following in your footer: F9 updates the field and hides the field code, showing the results. (You are showing paragraph marks, right?) Then press Ctrl+F9 and then F9.Ĭtrl+F9 creates the braces for a field.

Select the entire footer except for the final paragraph mark.

Select 'numpages ' and press Ctrl+F9 and then F9.

Select 'page' and press Ctrl+F9 and then F9.

In front of that type: 'If page = numpages ' without the quotation marks but with the space at the end.

Type what you want to appear in the footer.

See How to control the page numbering in a Word document.You will be operating in the footer. You do not need a section break to do this.

Section breaks are good things when you need them, otherwise they cause confusion and delay.

How to add footer in excel 2016 mac