How to Format the Font in Headers and Footers in Excel The buttons are “Format Text,” “Insert Page Number,” “Insert Number of Pages,” “Insert Date,” “Insert Time,” “Insert File Path,” “Insert File Name,” “Insert Sheet Name,” “Insert Picture” and “Format Picture.” Click any of these buttons to insert that type of information into the currently selected area in your custom header or footer.Ĭreate Headers and Footers in Excel – Instructions: A picture of the “Header” dialog box you can open from the “Page Setup” dialog box in Excel. In addition, Excel also gives you buttons that let you add preset fields of information into those sections of your custom headers and footers. Then type the header or footer information to show into those spaces. Then, in either the “Header” or “Footer” dialog box, click into either the “Left section,” “Center section,” or “Right section” fields. How to Create Custom Headers and Footers in ExcelĪlternatively, to create a custom header or footer in Excel into which you can type your own data, click the “Custom Header…” or “Custom Footer…” buttons to open either a “Header” or “Footer” dialog box. To apply preset header or footer information in Excel, use the “Header” and/or “Footer” drop-downs on this tab to select a set of data to show. The current worksheet’s header and footer appear on the “Header/Footer” tab. Then click the “Header/Footer” tab within the dialog box. Then click the “Page Setup” dialog box button in the lower-right corner of the “Page Setup” button group. To do this, click the “Page Layout” tab in the Ribbon.

To create headers and footers in Excel, open the “Page Setup” dialog box. Create Headers and Footers in Excel: Overview How to Create Headers and Footers in Excel

How to insert a header in excel online