Tip! This guide shows you how to add a header in a Google Sheet. Note that in order to add a Header or Footer, you will need to go to "Print" mode, as there's no way to add it otherwise.
Go to "File" or click the "Printer" button
Zoom Saved
Click "Print"
Zoom Saved
This will open up your Print Editor. Click "Headers & footers" on the bottom right
Zoom Saved
Edit your Header by clicking the checkboxes, for example you can select "Page numbers," "Workbook title" or "Sheet name"
Zoom Saved
To make other changes, click "EDIT CUSTOM FIELDS"
Zoom Saved
Click on "Click to add text" to give your sheet a title.
Zoom Saved
Type in your title
Zoom Saved
You can also add text to the center of the header
Zoom Saved
You can also edit where it says "Sheet1" on the right hand side
Zoom Saved
Click "CONFIRM"
Zoom Saved
If you would like to add the sheet as a PDF or print, click "NEXT"
Zoom Saved
To save as a PDF, click "Save"
Zoom Saved
Your header will stay in tact if you ever need to print or download the sheet again
Zoom Saved
Documents you might like
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe
Have something to say?Create an account to leave messages for the author to see!
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key