3 Simple Steps to add Header and Footer in Google Sheets
Learn how to add Header and Footer in Google Sheets.
Introduction
Headers and Footers are the information present at the top and bottom of a page respectively. So when we need some information to be displayed repetitively on all the pages, we can make use of the header and footer in Google Sheets.
Headers and Footers are useful in a spreadsheet to provide quick information of a document in a predictable format.
Unlike Microsoft Excel, which has a direct option to add Headers and Footers, Google Sheets does not offer such an option. However, there is a (roundabout) way it can be done via the Print settings. Now let’s dive straight into how to do that.
Example Data
My sample data here consists of a list of grocery products along with their prices. I will demonstrate how to add header and footer to this example spreadsheet in this article.
Steps to Insert Header and Footer in Google Sheets
Step 1: Choose Print option
Click on File -> Print. You can also press Ctrl + P (on Windows) or Cmd + P (on Mac).
Step 2: Select Header and Footer option
In the Print settings, select the Header and Footer option.
The following list of options appears on the screen,
Step 3: Insert Header and Footer
Once you select any of the available options, the specified header and footer will appear on the spreadsheet page. The figure shown below demonstrates this.
Inserting Custom Header and Footer in Google Sheets
- In the Print settings, click on Edit custom fields.
The following page appears after you click on the above mentioned option.
When we click on any of the blanks in this sheet, a list of option appears. We can select any option from this list and insert a custom header and footer of our choice. The screenshot shown below demonstrates this.
See Also
Import JSON in Google Sheets: Learn how to import JSON in Google Sheets using the Apps Script Editor.
Link Google Sheets to Excel: Guide to help you link Google Sheets to Excel.