[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Excel is not only a powerful tool for data storage and transformation, it is also widely used for data analysis, so it offers a great range of features to make data more visually accessible. All Excel versions allow you to insert a header and footer to your spreadsheet, which can be pre-defined or custom.<\/p>\n
Adding headers and footers to your spreadsheets is a great way to visually improve your files, and make them ready in a professional setting, such as reports. Since headers and footers are mainly designed for printed pages, they won\u2019t interfere with your worksheet view; they are only visible in Print Preview and Page Layout view.<\/p>\n
In this article, we\u2019ll show you how to add a header in Excel for all pages, how to add a footer in your Excel spreadsheet, as well as how to edit a header and footer to showcase the information you need.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”why-add-a-header-and-footer-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Since most users are unaware that this feature exists, here are the main benefits of adding a header and footer in your Excel spreadsheet.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”how-to-add-a-header-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Now that you have seen what headers and footers are used for, we\u2019ll explain how to add a preset header in Excel.<\/p>\n
1.<\/strong> Go to Insert > Header & Footer. The worksheet should change to \u201cPage Layout\u201d view.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-header-insert-header-and-footer.webp” alt=”Excel header \u2014 Insert tab of the ribbon with the Header & Footer button above a blank worksheet” title_text=”Insert tab of the ribbon with the Header & Footer button above a blank worksheet” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> To add a preset header, click on \u201cAdd header\u201d, then click on the drop-down arrow in the \u201cHeader\u201d button to browse through the list of preset headers. These combine information relating to page number, file name, file path, date, etc.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-header-preset-headers-list.webp” alt=”Excel header \u2014 Header drop-down open with preset options such as Page 1, Confidential, and the file path” title_text=”Header drop-down open with preset options such as Page 1, Confidential, and the file path” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Once you click on a preset header, Excel automatically inserts the data following the preset order. Here, I selected the last preset, which includes information on the author and date in the center section, and the page number to the right.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-header-page-number-preset.webp” alt=”Excel header \u2014 page number preset at the top of the page in Page Layout view” title_text=”Page number preset at the top of the page in Page Layout view” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> To edit the order or contents of the preset header, simply click on the header section and change accordingly. Here, I will change the author\u2019s name to \u201cJ. Smith\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-header-edit-preset-header.webp” alt=”Excel header \u2014 edited header reading Prepared by J. Smith 09\/03\/2022 with Page # on the right” title_text=”Edited header reading Prepared by J. Smith 09\/03\/2022 with Page # on the right” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Click anywhere in your spreadsheet to leave the header area. If you want to leave without saving changes, press Esc. This header will now appear on all pages of your Excel spreadsheet, so make sure that you want this information on all printed pages.<\/p>\n Now that you\u2019ve seen how easy it was to insert a preset header in Excel, let\u2019s create your own custom header.<\/p>\n 1.<\/strong> Go to Insert > Header & Footer.<\/p>\n 2.<\/strong> Click on any of the header sections and type in the information you would like to include. You can also select one of the preset elements in the toolbar and arrange it according to your needs. Here, I will start by adding a \u201cPicture\u201d element to insert my company logo.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-header-picture-button.webp” alt=”Excel header \u2014 Header & Footer tab with the Picture button and empty left, center, and right header sections” title_text=”Header & Footer tab with the Picture button and empty left, center, and right header sections” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Browse for the image you want and select it. You can then click on \u201cInsert\u201d or double-click on the image file.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-header-insert-logo-picture.webp” alt=”Excel header \u2014 file browser with the Hollbook logo PNG selected and the Insert button” title_text=”File browser with the Hollbook logo PNG selected and the Insert button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Excel shows the "&[Picture]\u201d command to include the image you select. However, if you want to view the image in your spreadsheet, click anywhere outside the header box.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-header-picture-code.webp” alt=”Excel header \u2014 &[Picture] code in the left header section” title_text=”&[Picture] code in the left header section” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> Follow the same process for the other two sections of the header. Here, I will include the date in the center header section and the page number to the right.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-header-logo-date-page-number.webp” alt=”Excel header \u2014 Hollbook logo on the left, &[Date] in the center, and # on the right” title_text=”Hollbook logo on the left, &[Date] in the center, and # on the right” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Make sure that the image quality is good enough for printing and that it won\u2019t interfere with the rest of the data \u200cin the worksheet.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-add-a-footer-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Like the header, you\u2019ll see how easily you can add a footer in Excel.<\/p>\n 1.<\/strong> Go to Insert > Header & Footer or simply double-click on the footer box.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-footer-add-footer-box.webp” alt=”Excel footer \u2014 Add footer box at the bottom of the page in Page Layout view” title_text=”Add footer box at the bottom of the page in Page Layout view” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Click on the drop-down arrow in the \u201cFooter\u201d button to browse through the list of preset footers, which combine the same information as for the header.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-footer-preset-footers-list.webp” alt=”Excel footer \u2014 Footer drop-down open with presets such as Page 1, JANUARY, and 2021 REPORT.xlsx” title_text=”Footer drop-down open with presets such as Page 1, JANUARY, and 2021 REPORT.xlsx” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Make sure that the footer complements, not repeats, your header information. Since I included the company logo, date, and page number before, I will simply include the filename below, \u201c2021 REPORT.xlsx\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-footer-file-name.webp” alt=”Excel footer \u2014 center footer section showing the file name 2021 REPORT.xlsx” title_text=”Center footer section showing the file name 2021 REPORT.xlsx” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Remember that you can always edit by simply clicking on the box and applying the desired change.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-footer-edit-footer-section.webp” alt=”Excel footer \u2014 center footer section edited to read 2021 REPORT” title_text=”Center footer section edited to read 2021 REPORT” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Once you finish editing your footer in Excel, click outside the box or press \u201cEsc\u201d to leave without saving.<\/p>\n The steps to add a custom footer are almost identical to adding a custom header. The only difference is that you will enter data in the left, center, and right boxes at the bottom of the page, making sure that the data complement the one in the header.<\/p>\n Here, I have only included the file and sheet name, as the header already contains the company logo, date, and page number.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-footer-custom-footer.webp” alt=”Excel footer \u2014 custom footer with 2021 REPORT in the center and JANUARY on the right” title_text=”Custom footer with 2021 REPORT in the center and JANUARY on the right” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Adding a header or footer into your spreadsheet is a great way to turn your spreadsheets into a more professional, visual document. They are a great option to consider if you need to present your data to other team members or even your stakeholders.<\/p>\n By the end of this article, you have learned how to add a preset and custom header and footer to provide additional information on the spreadsheet. Although the examples in this article show how to add a header and footer in Excel for Mac, the steps shown here are very similar to Excel for Windows.<\/p>\n If you want to know more about how to organize and structure your data to make it more accessible, you will be interested in our article on conditional formatting in Excel: The complete guide<\/a>.<\/p>\n Headers and footers only appear in print and in Page Layout view. To keep column labels in sight while you scroll on screen, freeze rows and columns in Excel<\/a>. When the report is ready, you can sign the Excel document<\/a> and email the spreadsheet<\/a> to your team. If the report pulls numbers from several spreadsheets, Sheetgo’s AI automations<\/a> can collect them into one file on a schedule, so every printed copy starts from current data.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" D\u00e9couvrez comment ajouter un en-t\u00eate et un pied de page dans Excel avec un mod\u00e8le pr\u00e9d\u00e9fini ou votre propre texte, comme les num\u00e9ros de page, la date, le nom du fichier ou le logo de votre entreprise.<\/p>","protected":false},"author":2,"featured_media":266054,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[51],"tags":[],"class_list":["post-266040","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/266040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=266040"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/266040\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/266054"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=266040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=266040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=266040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to insert a custom header?<\/h3>\n
How to add a footer in Excel?<\/h2>\n
How to insert a preset footer?<\/h3>\n
How to insert a custom footer?<\/h3>\n
Conclusion<\/h2>\n