How to Create Headers in Google Sheets on Computer or Mac

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.

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

{“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.

{“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.

{“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 Calculate the Surface Area of a Rectangle

{“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.

{“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.

{“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.

{“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).

{“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.

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.

Related Search: