Header & Footer

Since Excel is often used to create business reports it would be useful to find information in the header or footer of the document that details them more closely. This can be: report name, label, company logo, date … And here you can insert the page number, the total number of pages, or some other information that is relevant to the appearance of the report. These functionalities contribute to the uniformity of the document and give it a more professional look.

00027-1Options for adjusting the header and footer of the document are part of Page Layout ribbon, and we activate them by clicking the button at the bottom right of the Page Setup group of options. After this action, a Page Setup dialog box opens, where you need to select the Header/Footer tab, in order to show the options for adjusting the header and footer. In the upper part of the window, the header and footer of the page are visible. Initially, they are not defined, so these fields are empty. Between them are two falling combo lists (Header, Footer), which allow us to select one of the offered values. However, it is recommended that the header and footer be manually set by clicking the Custom Header or Custom Footer button.

Starting one of these 00027-2options opens a dialog box with three sections: left, center and right. By clicking on one of the sections, we have the ability to enter arbitrary text in any of them. Above the section are icons with symbols of elements that we can enter. This can be the case: formatting the selected text (which we have previously entered in one of the sections), inserting the page number, the total number of pages, date, time, file path, filename, worksheet name, image insertion, and options for formatting the added image. The same elements could be found both in the header and in the footer, and the editing of the header or footer does not differ except in the view that part of the document is being changed.

At the bottom of the window there are four optional fields. By highlighting the first one (Different odd and even pages) it is emphasized that headers and footers differ on even and odd pages, so they are adjusted separately accordingly. This option can be selected if we print two-sided reports. The second optional field (Different first page) serves to create the header and footer separately for the first page in the document. The third field (Scale to fit) is used to adjust whether the header and footer are scaled together with other page elements, if we choose to scale the page to fit on one sheet. The last Align with page margins determines whether the alignment of the header and footers is done in accordance with the defined page margins.