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
Click "Print"
This will open up your Print Editor. Click "Headers & footers" on the bottom right
Edit your Header by clicking the checkboxes, for example you can select "Page numbers," "Workbook title" or "Sheet name"
To make other changes, click "EDIT CUSTOM FIELDS"
Click on "Click to add text" to give your sheet a title.
Type in your title
You can also add text to the center of the header
You can also edit where it says "Sheet1" on the right hand side
Click "CONFIRM"
If you would like to add the sheet as a PDF or print, click "NEXT"
To save as a PDF, click "Save"
Your header will stay in tact if you ever need to print or download the sheet again
Documents you might like
0 Selected
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