How to Create Column Headings in Google Sheets on Windows and Mac

Table of contents:

How to Create Column Headings in Google Sheets on Windows and Mac
How to Create Column Headings in Google Sheets on Windows and Mac
Anonim

This article explains how to add a new row to serve as a header for the columns of a Google Sheets sheet using a computer.

Steps

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

Step 1. Visit https://sheets.google.com using your computer's internet browser

If you haven't signed in with your Google account yet, do so now before continuing.

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

Step 2. Click on the icon of the file you want to edit

If you need to create a new spreadsheet, click on the "Blank" icon visible in the upper left part of the page that appears.

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

Step 3. Insert a blank line into the worksheet

If you have created a new document or if the file you have opened already has a row with column headings, you can skip this step. If not, follow these instructions to add a new line at the top of the existing ones:

  • Click on the number of the first row of the sheet. All matching cells will be selected and highlighted.
  • Click on the menu insert.
  • Click on the option Row above. At this point, a completely blank line should have appeared at the top of the worksheet under examination.
Make a Header on Google Sheets on PC or Mac Step 4
Make a Header on Google Sheets on PC or Mac Step 4

Step 4. Enter the column headings inside the cells of the row you just added

If the column headings were already present on the sheet, you can skip this step. Otherwise, type the name of the corresponding column in each cell of the first row of the sheet.

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

Step 5. Click on the row number where the column headings are visible

All matching cells will be selected and highlighted.

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

Step 6. Click on the View menu

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

Step 7. Click on the Block option

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

Step 8. Click on the 1 line item

The row containing the individual column headings will be locked in place. This means that it will always be visible as the first row of the spreadsheet even when you scroll down.

To be able to sort and filter the data by clicking on the column header, click on the number of the row that contains the column headings, click on the menu Data, then select the item Filter. At this point you can sort the data by simply clicking on the green icon that appeared in each cell of the header row of the sheet.

Recommended: