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