To print different header or footer information for odd and even pages, the first page, or both, check either or both the “Different odd and even pages” and/or the “Different first page” checkboxes, as needed. 5. You can use the “Header” and “Footer” drop-down boxes on this tab to select from some pre-made standard heading information. To add an image, click the image button (the second-to-last one), and then follow the on-screen instructions to find and select an image. Thanks to all authors for creating a page that has been read 35,110 times. Excel Podcast. 1. Active your worksheet which you want to insert herder or footer with a cell value, then hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. 2. Also, you do not want to display “Page” and only want the page number. Then create its content the same way as when creating a single custom header or footer. Excel offers a variety of options to be put up as Header/Footer text such as Date, Time, Sheet Name, File Name, Page Number, Custom Text, etc. Click Insert. This has been a guide to Header and Footer in Excel. Every dollar contributed enables us to keep providing high-quality how-to help to people like you. Click the paint can button at end of the row to edit the image. Then click on the header/footer tab and again click on the custom header. The following video lesson, titled “Creating Headers and Footers,” shows how to create headers and footers in Excel. Let me now go to custom footer. 3. Then create the headers and/or footers the same way as when creating a single custom header or footer. You just use the template to create a new Excel file, and fill in the data. To add the date and/or time, click the desired spot, then click the calendar (for date) and/or the clock (for time). First click on the print preview and click on the page setup. If you want to place a cell content in the header or footer of the current worksheet, the following VBA code can help you. Double click on This Workbook in the Project Explorer. In either dialog box, click into either the “Left section,” “Center section,” or “Right section” boxes. Then type your header or footer information into those spaces provided. Include your email address to get a message when this question is answered. Then click the “Format Text” button to modify its font and font size. We've been helping billions of people around the world continue to learn, adapt, grow, and thrive for over a decade. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bc\/Add-a-Footer-in-Excel-Step-1.jpg\/v4-460px-Add-a-Footer-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/b\/bc\/Add-a-Footer-in-Excel-Step-1.jpg\/aid1035298-v4-728px-Add-a-Footer-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"