{"id":12803,"date":"2022-12-20T12:43:19","date_gmt":"2022-12-20T12:43:19","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=12803"},"modified":"2024-03-26T10:35:46","modified_gmt":"2024-03-26T10:35:46","slug":"align-header-and-footer","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/","title":{"rendered":"Align Header and Footer in Excel"},"content":{"rendered":"\n
Align-Header-and-Footer-in-Excel<\/a>Download File<\/a><\/div>\n\n\n\n

Just like in Microsoft Office Word, we have options to manipulate the header and footer<\/strong> in Excel as well.<\/p>\n\n\n\n

In the example below, we will show you how to add a header and footer, and how to align them in your file.<\/p>\n\n\n\n

Add Header and Footer<\/h2>\n\n\n\n

For our example, we will use the table with NBA players and their statistics<\/strong> from several categories: points, rebounds, assists, and turnovers:<\/p>\n\n\n\n

\"Table\n\nDescription<\/figure>\n\n\n\n

Our header and footer can be virtually anything that we want, and it can be any data type<\/strong>: numbers, text, dates, etc. To add it, we will go to the Page Layout tab<\/strong> and then go to Page Setup<\/strong> and choose the small icon in the bottom right corner<\/strong> to expand the window:<\/p>\n\n\n\n

\"Table\n\nDescription<\/figure>\n\n\n\n

On a window that appears, we will choose the Header\/Footer tab<\/strong>. In there, there are a couple of options for us. We can choose one of the options for header or footer on a dropdown<\/strong>, or click on Custom Header\/Custom Footer options<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

For our example, we will use Custom Header and Custom Footer option<\/strong>. When we click on the Custom Header<\/strong>, we will have a new window opened. In there, we will choose to have a header in the Right section<\/strong>, and choose it to be a number of a page<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

We will click OK<\/strong>, then choose to customize the Footer<\/strong>. A window with the same options will appear, and we will choose to center the Footer and show the time<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

When we click OK<\/strong>, we go and click on the Print Preview option<\/strong> in our window:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

Align Header and Footer<\/h2>\n\n\n\n

We can align the header and footer in terms of their position on a page<\/strong>. To do this, we will repeat the same steps that we made when we created them, and that is to go to Page Layout and find Page Setup<\/strong>. Only this time, we will choose the Margins tab<\/strong>.<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

Beforehand, in the first step of the process, we need to choose the option \u201calign with page margins\u201d<\/strong> under the Header\/Footer tab<\/strong> which basically means that our header and footer will be aligned relative to the page margins, not to the edge of our page:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

Back on the Margins tab<\/strong>, our goal for aligning the header and footer is to always have them in the same size, and that their values are smaller than the values of the Bottom and Top Margin<\/strong>. Otherwise, the header and footer could overlap the margins. We will increase our numbers just a little bit:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

And will check the header and footer in the Print Preview<\/strong>:<\/p>\n\n\n\n

\"Table\n\nDescription<\/figure>\n\n\n\n

If we would have gone on and added a header and footer in all positions (left, center, and right) we would see that they are perfectly aligned:<\/p>\n\n\n\n

\"Table\n\nDescription<\/figure>\n","protected":false},"excerpt":{"rendered":"

Just like in Microsoft Office Word, we have options to manipulate the header and footer in Excel as well. In the example below,…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nAlign Header and Footer in Excel<\/title>\n<meta name=\"description\" content=\"Download the Align-Header-and-Footer-in-Excel file and learn how to add, align and manipulate headers and footers in Microsoft Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Align Header and Footer in Excel\" \/>\n<meta property=\"og:description\" content=\"Download the Align-Header-and-Footer-in-Excel file and learn how to add, align and manipulate headers and footers in Microsoft Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-20T12:43:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T10:35:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/table-description-automatically-generated-7.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Align Header and Footer in Excel\",\"datePublished\":\"2022-12-20T12:43:19+00:00\",\"dateModified\":\"2024-03-26T10:35:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/\"},\"wordCount\":464,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/table-description-automatically-generated-7.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/\",\"name\":\"Align Header and Footer in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/table-description-automatically-generated-7.png\",\"datePublished\":\"2022-12-20T12:43:19+00:00\",\"dateModified\":\"2024-03-26T10:35:46+00:00\",\"description\":\"Download the Align-Header-and-Footer-in-Excel file and learn how to add, align and manipulate headers and footers in Microsoft Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/table-description-automatically-generated-7.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/table-description-automatically-generated-7.png\",\"width\":578,\"height\":225,\"caption\":\"Table Description automatically generated\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Align Header and Footer in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Align Header and Footer in Excel","description":"Download the Align-Header-and-Footer-in-Excel file and learn how to add, align and manipulate headers and footers in Microsoft Excel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/","og_locale":"en_US","og_type":"article","og_title":"Align Header and Footer in Excel","og_description":"Download the Align-Header-and-Footer-in-Excel file and learn how to add, align and manipulate headers and footers in Microsoft Excel.","og_url":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/","article_published_time":"2022-12-20T12:43:19+00:00","article_modified_time":"2024-03-26T10:35:46+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/table-description-automatically-generated-7.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Align Header and Footer in Excel","datePublished":"2022-12-20T12:43:19+00:00","dateModified":"2024-03-26T10:35:46+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/"},"wordCount":464,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/table-description-automatically-generated-7.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/","url":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/","name":"Align Header and Footer in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/table-description-automatically-generated-7.png","datePublished":"2022-12-20T12:43:19+00:00","dateModified":"2024-03-26T10:35:46+00:00","description":"Download the Align-Header-and-Footer-in-Excel file and learn how to add, align and manipulate headers and footers in Microsoft Excel.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/table-description-automatically-generated-7.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/table-description-automatically-generated-7.png","width":578,"height":225,"caption":"Table Description automatically generated"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/align-header-and-footer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Align Header and Footer in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12803"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=12803"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12803\/revisions"}],"predecessor-version":[{"id":13891,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12803\/revisions\/13891"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=12803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=12803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=12803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}