Microsoft Excel is a spreadsheet application which not only stores and presents data in tabular format but can also be used for printing reports and data in very professional manner. Print given by Excel depends upon the length and breadth of the table which you want to print and the columns often get shared on multiple pages of A4 size which later can be stuck together to give the entire view to the table. Just like Microsoft Word we can also have Headers and Footers in Excel pages and can customize them as well. Just to quote the Header and Footer section of Excel or any Word document is used to print some key information regarding the document. This is basically the margin area which can be used for writing the page number, documents title, chapter number, chapter title, or any other reference text. In Microsoft Word or Excel users get various options of customizing it and it can also be automated. Users can select some predefined fields in these sections so that it gets updated automatically as you type. You must be familiar with such options in Microsoft Word application but in this post I will discuss about the same feature in Microsoft Excel. Though the purpose remains the same but the interface and places to look for these options is different in Microsoft Excel.
Steps to add header or footer or both in Excel spreadsheet:
Step1: Open the document in which you want to make these amendments
Step2: Open the View ribbon to get the viewing options.
Step3: Click on the Page Layout view to see the tables the way they way they will be distributed on printed papers. It is advised to set the correct margins first so that you get the correct number of columns and you can even use header section to type the field names so that it appears on every page. Please note that you would need to unfreeze the panes because freezing of panes doesn’t work in the page layout view.
Step4: Once you get the Page layout view up on the screen you would be able to see the headers and footers sections available as according to the margin sizes. By default there are three sections each in Header and the Footer and they are termed as Left section, Center section, and the Right section.
Step5: Hover your mouse pointer over these sections and click to make them editable.
Step6: As Header or the Footer section becomes editable a hidden ribbon called as Design appears and it contains options specific to the Header and the Footers.
Step7: Now you can either enter a custom text or you can use the design ribbon to enter the predefined set of fields. Some example of predefined set of fields is like the page number, Date, Time, File name, File path, or any picture (which generally is the logo of your organization).
Step8: additionally you can have some more option related to the settings of the same and they are available in the options box of the Design Ribbon.