How to set headers and footers in Google Sheets | Scribe

    How to set headers and footers in Google Sheets

    • |
    • 9 steps |
    • 18 seconds
    information ordinal icon
    This Scribe shows you how to add footers and headers in Google Sheets. Note that a Google sheet won't have a visible headers and footers until you decide to print.
    1
    Navigate to your spreadsheet
    2
    Click "File" and then "Print"
    Click "File" and then "Print"
    3
    Open up the "Headers & footers" section of the menu that appears on the right hand panel
    4
    Checking "Page numbers" will have them appear on the lower right corner
    Checking "Page numbers" will have them appear on the lower right corner
    5
    Checking "Workbook title" will have it appear on the upper left corner
    Checking "Workbook title" will have it appear on the upper left corner
    6
    Checking "Sheet name" will have it appear on the upper right corner
    Checking "Sheet name" will have it appear on the upper right corner
    7
    Checking "Current date" will have it appear on the lower left corner
    Checking "Current date" will have it appear on the lower left corner
    8
    Checking "Current time" will append itself to the current date in the lower left corner
    Checking "Current time" will append itself to the current date in the lower left corner
    9
    Click "Next" to print!