Header and Footer are very important portions of a report or presentation, when we are finalizing the reports.
First of all, let us understand what is a HEADER and what is a FOOTER.
HEADER IS THE INFORMATION WHICH IS PRESENT ON THE TOP OF EACH AND EVERY PAGE OF THE GOOGLE SHEET [ WHILE PRINTING ].
Similarly , FOOTER IS THE INFORMATION WHICH IS PRESENT AT THE BOTTOM OF ALL THE PAGES.
If we need some text to be present in all the pages, we make use of header or footer. There is different reserved space for them and the text can be edited only after we have changed it through the specific option of header and footer.
Let us learn how we can easily insert a header and a footer in Excel Sheets.
The HEADER AND FOOTER option appears in the PRINT OPTION under the FILE MENU.
The following picture shows the presence of HEADER AND FOOTER OPTION in GOOGLE SHEETS.
Let us take a sample data and then apply header and footer to the same.
The Sample data is shown below.
The data can be anything. We have taken a sample data as shown in the picture below.
Let us add a HEADER and FOOTER on the given data.
As we click HEADERS AND FOOTERS, the direct options for applying the header and footer appears.
The following picture shows the different options.
The options available are
You can select any of the available options of and it’ll appear on the page.
The locations are already set and can’t be changed of the already available options.
The following picture shows the location of the different Headers and Footers in the google sheet.
[ Don’t worry ! We have got Custom Header and Footer option for further control. Discussed in next section. ]
As we select the header and footer options, the relevant header or footer appears on the print preview and we can print the page.
Now let us learn to insert custom header or footer in google sheets.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE