{"id":3681,"date":"2018-12-12T19:23:00","date_gmt":"2018-12-12T19:23:00","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3681"},"modified":"2024-03-26T16:03:54","modified_gmt":"2024-03-26T16:03:54","slug":"headers-and-footers","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/headers-and-footers\/","title":{"rendered":"Headers and Footers in Excel"},"content":{"rendered":"\n

If you work with Word, there is a big change that you worked with headers<\/strong> and footers<\/strong>. But they are available not only in Word. You can also use them in Excel.<\/p>\n\n\n\n

The header is located above the content of the page and the footer is below the content.<\/p>\n\n\n\n

Generally, they contain basic information about the company name, company logo, page number, or date.<\/p>\n\n\n\n

Microsoft included a bunch of built-in headers and footers you can choose from, but you can also create your own.<\/p>\n\n\n\n

Adding header<\/h2>\n\n\n\n

In order to add a header to the Excel worksheet on every page, follow these steps:<\/p>\n\n\n\n

    \n
  1. Navigate to Insert >> Text >> Header & Footer<\/strong>. This will switch to the Page Layout<\/strong><\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
      \n
    1. Inside the Layout window, there is a new area called Header & Footer Tools<\/strong> with the single tab – Design<\/strong>. Click it.<\/li>\n\n\n\n
    2. Inside this tab, there are a few things you can add, such as text<\/strong>, page number<\/strong>, current date<\/strong>, current time<\/strong>, file path<\/strong>, file name<\/strong>, sheet name<\/strong>, picture<\/strong>.<\/li>\n<\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
        \n
      1. If you want to leave the header area, click anywhere inside the worksheet. If you don\u2019t want to keep changes press Esc<\/strong>.<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        Adding footer<\/h2>\n\n\n\n

        Adding a footer to an Excel document is very similar to adding a header.<\/p>\n\n\n\n

          \n
        1. Click Insert >> Text >> Header & Footer<\/strong> to switch the view to Page Layout<\/strong>.<\/li>\n\n\n\n
        2. In Design >> Navigation<\/strong>, click Go to Footer<\/strong>.<\/li>\n<\/ol>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
            \n
          1. The button will become grayed out.<\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
              \n
            1. And the cursor will move to the bottom of the page.<\/li>\n<\/ol>\n\n\n\n
              \"\"<\/figure>\n\n\n\n
                \n
              1. You can type text or add one of the elements from Header & Footer Elements<\/strong>.<\/li>\n<\/ol>\n\n\n\n

                Adding a preset header or footer<\/h2>\n\n\n\n

                Excel offers a few built-in headers and footers which you can add to your document with a single mouse click.<\/p>\n\n\n\n

                  \n
                1. Navigate to Insert >> Text >> Header & Footer<\/strong>. It will switch the document to the Page Layout<\/strong><\/li>\n\n\n\n
                2. Under Design >> Header & Footer<\/strong>, you have two options: Header<\/strong> and Footer<\/strong>.<\/li>\n<\/ol>\n\n\n\n
                  \"\"<\/figure>\n\n\n\n
                    \n
                  1. Click one of the buttons to expand the preset list and choose the one you need.<\/li>\n<\/ol>\n\n\n\n
                    \"\"<\/figure>\n\n\n\n

                    And this is how this preset looks on the worksheet.<\/p>\n\n\n\n

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

                    You have to remember that you need to have some information on any of the sheets, otherwise you will have the hash (#<\/strong>) sign, instead of the page number.<\/p>\n\n\n\n

                    What you need to know about presets is that they are dynamic. If you make some modifications inside your worksheet, it will automatically change the header or footer.<\/p>\n\n\n\n

                    Creating a custom header or footer<\/h2>\n\n\n\n

                    Instead of using predefined headers or footers, you can create your own. In this custom header we are going to add:<\/p>\n\n\n\n