How to Create a Header in a Google Sheet Using a PC or Mac

Table of contents:

How to Create a Header in a Google Sheet Using a PC or Mac
How to Create a Header in a Google Sheet Using a PC or Mac

Video: How to Create a Header in a Google Sheet Using a PC or Mac

Video: How to Create a Header in a Google Sheet Using a PC or Mac
Video: How to Insert Multiple Rows on Google Sheets on PC or Mac? 2024, November
Anonim

This article teaches you how to add column headers to a Google Sheet spreadsheet on a computer.

Step

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. Go to https://sheets.google.com using a browser

If you're not already signed in to your Google account, sign in now.

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 the sheet you want to edit

To create a new sheet, click the “Blank” or “Blank document” option in the top-left corner of the list.

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 new blank line into the sheet

If you are creating a new sheet or already have a header row, skip this step. If you haven't already, follow these steps to add a new row at the top of the sheet:

  • Click the number next to the top row of the sheet. This process will block the row.
  • Click menu Insert or Insert
  • Click Row above or Line above. A blank line will appear at the top of the sheet.
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. Type the header into the header row

If you have already given column/header names, skip this step. If not, type the title of each column into the blank box at the top of the data.

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 the number next to the header row

This process will block the header row.

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 the View menu or See.

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 Freeze or Freeze.

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 1 row or 1 line.

The header row is now frozen. If you scroll down the spreadsheet, these rows will remain visible.

To turn on the sort and filter data feature by clicking the column header, clicking the header row number, clicking the menu Data, then select Filter or Create filters. Now, you can sort the data by clicking the green icon in each header.

Recommended: