How to add a header or footer in Google Sheets
Headers and Footers usually contain information such as the document title, author name, date or version number. This helps in identifying the document easily, especially when printed or shared.
How to add a header in Google Sheets
If you are printing and sharing your spreadsheet, headers and footers can add important context and make your data easier to organize.
1. Navigate to your spreadsheet.
Open your spreadsheet from your Google Drive or knowledge base.
2. Click "File."
This is in the menu at the top of your sheet.
3. Click "Print."
You do not need to print the document to set the header options, however they will only show up on the printed sheet.
4. Click "Headers & footers."
This section of the menu will appear on the right hand panel.
5. Select your header options.
This includes: Workbook title anf Sheet name, which will appear on the upper lefthand corner of the printed sheet.
6. Click "Next."
This will take you to printing instructions. And then you're done!
How to add a footer in Google Sheets
With a footer, you can add page numbers and important time stamps to help you sort and reference printed Google Sheets.
1. Navigate to your spreadsheet.
Open your spreadsheet from your Google Drive or knowledge base software.
2. Click "File."
This is in the menu at the top of your sheet.
3. Click "Print."
You do not need to print the document to set the header options, however they will only show up on the printed sheet.
4. Click "Headers & footers."
This section of the menu will appear on the right hand panel.
5. Select your footer options.
This includes: Page number, Current date and Current time which will appear in the lower lefthand corner of your sheet.
6. Click "Next."
This will take you to printing instructions. And then you're done!
Get more Google Sheets guides and make your own
Scribe has thousands of guides for Google Sheets, Excel and so much more. Sign up for a free account to save and share this guide with your team.
Scribe is an AI-powered process documentation tool that turns any workflow into a visual step-by-step guide — complete with text, links and annotated screenshots. Build guides for your colleagues and clients in seconds. All for free!
Like this guide? Check out these related resources
- Google Sheets 101: Google Sheets Tutorial — Everything You Need to Know to Be an Expert ‍
- Free Tool: Google Sheets Training Generator‍
- Step-by-Step Guide: How to Lock a Row in Google Sheets
- Free Tool: Google Flowchart Generator
- Step-by-step Guide: How to Create a Drop Down in Google Sheets
