How to add a header in Google Sheets | Scribe

    How to add a header in Google Sheets

    • |
    • 13 steps |
    • 46 seconds
      information ordinal icon
      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