• About
  • Contact
  • Cookie
  • Disclaimer
  • Privacy Policy
  • Change the purpose of use

Tnhelearning.edu.vn - Various useful general information portal

  • Photo
  • Bio
  • How To
  • Tech

How to Create Headers in Google Sheets on Computer or Mac

February 18, 2024 by admin Category: How To

You are viewing the article How to Create Headers in Google Sheets on Computer or Mac  at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.

X

This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.

The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.

This article has been viewed 5,003 times.

This article shows you how to insert a Header row containing a column header into a spreadsheet when using Google Sheets on a computer.

Steps

Image titled Make a Header on Google Sheets on PC or Mac Step 1

Image titled Make a Header on Google Sheets on PC or Mac Step 1

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e7/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg/ v4-728px-Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ e/e7/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg/v4-728px-Make-a-Header-on-Google-Sheets-on-PC- or-Mac-Step-1.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”<div class=”mw-parser-output “></div>”}
Go to https://sheets.google.com using a web browser. If you’re not signed in to your Google account, you need to sign in now.
Image titled Make a Header on Google Sheets on PC or Mac Step 2

Image titled Make a Header on Google Sheets on PC or Mac Step 2

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/48/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg/ v4-728px-Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 4/48/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg/v4-728px-Make-a-Header-on-Google-Sheets-on-PC- or-Mac-Step-2.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output “></div>”}
Click the spreadsheet you want to edit. To create a new worksheet, you need to click on the “Blank” option located in the upper left corner of the list.
Image titled Make a Header on Google Sheets on PC or Mac Step 3

Image titled Make a Header on Google Sheets on PC or Mac Step 3

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/73/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg/ v4-728px-Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 7/73/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg/v4-728px-Make-a-Header-on-Google-Sheets-on-PC- or-Mac-Step-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser-output “></div>”}
Insert a blank row into the spreadsheet. If you have created a new worksheet or already have a Header row, you can skip this step. If not, you need to follow the steps below to add a new row to the top of the spreadsheet:

  • Click the number next to the top row in the spreadsheet. This is the step to bold the whole row.
  • Click the Insert menu .
  • Click Row above . There will now be a blank row at the top of the spreadsheet.
READ More:   How to Become a Free Software Developer
Image titled Make a Header on Google Sheets on PC or Mac Step 4

Image titled Make a Header on Google Sheets on PC or Mac Step 4

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1f/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg/ v4-728px-Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 1/1f/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg/v4-728px-Make-a-Header-on-Google-Sheets-on-PC- or-Mac-Step-4.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output “></div>”}
Type a title in this Header row. If you already have a column/header name, you can skip this step. If not, you need to type the title for each column in the empty cell at the top of the data table.
Image titled Make a Header on Google Sheets on PC or Mac Step 5

Image titled Make a Header on Google Sheets on PC or Mac Step 5

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7d/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg/ v4-728px-Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 7/7d/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg/v4-728px-Make-a-Header-on-Google-Sheets-on-PC- or-Mac-Step-5.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”<div class=”mw-parser-output “></div>”}
Click the number next to the Header row. This is the step to bold the whole row.
Image titled Make a Header on Google Sheets on PC or Mac Step 6

Image titled Make a Header on Google Sheets on PC or Mac Step 6

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d4/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg/ v4-728px-Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ d/d4/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg/v4-728px-Make-a-Header-on-Google-Sheets-on-PC- or-Mac-Step-6.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output “></div>”}
Click the View menu.
Image titled Make a Header on Google Sheets on PC or Mac Step 7

Image titled Make a Header on Google Sheets on PC or Mac Step 7

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a0/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg/ v4-728px-Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ a/a0/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg/v4-728px-Make-a-Header-on-Google-Sheets-on-PC- or-Mac-Step-7.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser-output “></div>”}
Click Freeze (Fixed).
  • Image titled Make a Header on Google Sheets on PC or Mac Step 8

    Image titled Make a Header on Google Sheets on PC or Mac Step 8

    {“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6e/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg/ v4-728px-Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/ 6/6e/Make-a-Header-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg/v4-728px-Make-a-Header-on-Google-Sheets-on-PC- or-Mac-Step-8.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541,”licensing”:”<div class=”mw-parser-output “></div>”}
    Click 1 row (1 row). The Header row is now fixed, which means it will stay in place as you scroll down the spreadsheet.

    • To enable the feature that allows you to sort and filter your data by clicking on the Header containing the column, you need to click the number of the Header row, then click the Data menu, then Filter . You can now click the green icon in each Header to sort the data.
  • X

    This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.

    The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.

    This article has been viewed 5,003 times.

    This article shows you how to insert a Header row containing a column header into a spreadsheet when using Google Sheets on a computer.

    Thank you for reading this post How to Create Headers in Google Sheets on Computer or Mac at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.

    READ More:   How to Say "No Chi" in French

    Related Search:

    Related Posts

    How to Create Curved Text in Photoshop
    How to fall asleep faster
    How to Install FBReader to Read eBooks

    Category: How To

    Previous Post: « How to Find Friends on TikTok Using iPhone or iPad
    Next Post: How to Change iMessage Color »

    Copyright © 2025 · Tnhelearning.edu.vn - Useful Knowledge