How to Make a Header on Google Sheets on PC or Mac

This wikiHow teaches you how to add a column header row to a spreadsheet using Google Sheets on a computer.

Steps

  1. Image titled Make a Header on Google Sheets on PC or Mac Step 1
    1
    Go to https://sheets.google.com in a web browser. If you're not already signed in to your Google account, sign in now.
  2. Image titled Make a Header on Google Sheets on PC or Mac Step 2
    2
    Click the sheet you want to edit. To create a new sheet, click the “Blank” option at the top-left corner of the list.
    Advertisement
  3. Image titled Make a Header on Google Sheets on PC or Mac Step 3
    3
    Insert a blank row into the sheet. If you created a new sheet or already have a header row, you can skip this step. Otherwise, follow these steps to add a new row at the top of the sheet:
    • Click the number beside the top row in the sheet. This highlights the row.
    • Click the Insert menu.
    • Click Row above. There should now be a blank row at the top of the sheet.
  4. Image titled Make a Header on Google Sheets on PC or Mac Step 4
    4
    Type your headers into the header row. If you've already given the columns names/headers, you can skip this step. Otherwise, type the title for each column into the blank cell at the top of the data.
  5. Image titled Make a Header on Google Sheets on PC or Mac Step 5
    5
    Click the number beside the header row. This highlights the row.
  6. Image titled Make a Header on Google Sheets on PC or Mac Step 6
    6
    Click the View menu.
  7. Image titled Make a Header on Google Sheets on PC or Mac Step 7
    7
    Click Freeze.
  8. Image titled Make a Header on Google Sheets on PC or Mac Step 8
    8
    Click 1 row. The header row is now frozen, which means it will stay in place as you scroll down the spreadsheet.
    • To turn on the feature that lets you sort and filter data by clicking the column header, click the row number of the header row, click the Data menu, then select Filter. Now you can click the green icon in each header to sort data.
    9. Advertisement

You Might Also Like

Turn Off Google Safesearch
How to
Turn Off Google Safesearch
Sign Out of Your Google Account on All Devices at Once
How to
Sign Out of Your Google Account on All Devices at Once
Restore Google AuthenticatorHow to Restore Google Authenticator if You Lost or Reset Your Phone
Fix the "Google Play Store Has Stopped" Error
How to
Fix the "Google Play Store Has Stopped" Error
Google Sheets How to Insert Time in Cell Automatically4 Easy Ways to Add the Time and Date Automatically in Sheets
Write a Review on Google2 Ways to Write a Review on Google
Turn Off Google Ads
How to
Turn Off Google Ads
Get a Google Voice Phone NumberHow to Sign Up for a New Google Voice Phone Number
Search by Image on GoogleReverse Image Search in Google Lens: Android, iPhone, & Desktop
Make a Google Account5 Easy Steps to Create a Google Account on Any Device
Make a Time Slot Sign Up Sheet on Google FormsHow to Make a Sign Up Sheet with Time Slots in Google Forms
Do Google GravityHow to Do the Google Gravity Trick in Your Browser
Create a Website Using Google Sites
How to
Create a Website Using Google Sites
Delete a YouTube Account
How to
Delete a YouTube Account
Advertisement

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 166,590 times.
How helpful is this?
Co-authors: 2
Updated: September 6, 2019
Views: 166,590
Categories: Google Applications
Article SummaryX

1. Sign in to Google Sheets.
2. Open a file.
3. Insert a blank row at the top.
4. Type headers into the row.
5. Click the row number of the header row.
6. Click View.
7. Click Freeze.
8. Click 1 row.

Did this summary help you?
Advertisement