Add a header row by inserting a blank row at the top, then typing your column names

A header row is the first row of your spreadsheet, where you name each column. Google Sheets does not create one automatically — you decide which row becomes your header and what each column contains. The simplest approach is to insert a blank row at the very top, type your column names there, and then add your data below.

Headers make your spreadsheet readable. When you come back to it in three months, you will know what each column means. They also let you sort, filter, and organize your data without accidentally mixing up which column is which. A header row is especially useful if you share the spreadsheet with someone else — they when ready understand what the numbers and text represent.

Key Takeaways

  • Right-click row 1, select "Insert 1 above", and type your column names into the new blank row.
  • You can freeze your header row so it stays visible when you scroll down through your data.
  • Google Sheets can turn your header row into a filter, letting you sort and hide data without changing the spreadsheet itself.
  • If your data already exists without headers, insert a row at the top and add names retroactively.
  • Keep header names short and clear so they fit in columns and work well if you later write formulas.

Insert a blank row and name your columns

Open your Google Sheet. Click on the row number "1" on the left side to select the entire first row. Right-click and choose "Insert 1 above". A new blank row appears at the top, and any data that was in row 1 moves down to row 2.

Click on the first cell in that new row and type your first column name — for example, "Date" or "Name". Press Tab to move to the next cell and type the next column name. Keep going until you have named all the columns you plan to use. You do not have to fill in every possible column; only name the ones that will hold data.

If you are starting a new spreadsheet from scratch, you can skip the insert step and straightforward type your headers directly into row 1. The insert method is only necessary if you already have data in row 1 that you want to keep below your headers.

Freeze your header so it does not scroll away

When your spreadsheet grows and you scroll down to see more rows, your header row scrolls away too. Freezing the header keeps it visible at the top no matter how far down you go. This is especially helpful when you have dozens or hundreds of rows of data.

Click on row 2 (the first row of actual data, below your headers). Go to the menu and select View, then "Freeze" and "1 row". The header row now stays locked at the top. You will see a faint line between row 1 and row 2 showing where the freeze happens. When you scroll down, row 1 remains visible while the rows below move past it.

Turn your header row into a filter

Google Sheets can add dropdown arrows to your header cells, letting you sort and hide data without changing the spreadsheet. Click any cell in your header row. Go to Data in the menu and select "Create a filter".

A small arrow appears in each header cell. Click an arrow to sort that column from A to Z, from smallest to largest, or to hide certain rows. For example, if your header is "Status" and you only want to see rows marked "Complete", click the arrow and uncheck "Incomplete". The other rows hide but are not deleted — they come back if you change the filter later.

Add headers to a spreadsheet that already has data

If you built your spreadsheet without headers and your data starts in row 1, insert a blank row at the top. Click row 1, right-click, and choose "Insert 1 above". Your data moves down to row 2.

Now type your column names into the new row 1. This does not change your data — it just labels what each column means. You can now freeze, filter, or sort without confusion. This is a common situation if you started by typing data directly without planning the structure first.

Use consistent naming for headers

Keep your header names short and clear. "Date" is better than "When this happened". "Amount" is better than "How much money". Short names fit better in narrow columns and are easier to reference if you later write formulas that refer to column names.

Avoid spaces and special characters if you can — use "FirstName" or "First_Name" instead of "First Name". This matters less in Google Sheets than in some other tools, but it prevents confusion if you ever move your data elsewhere or share it with someone using different software. Consistency also makes your spreadsheet easier to read at a glance.

Frequently Asked Questions

Can I have more than one header row?

Yes. You can freeze multiple rows if you need them. Click on the row below your last header row, go to View, select Freeze, and choose how many rows to lock. Google Sheets will freeze all rows above the one you selected.

What if I want to rename a header after I have already added data?

Click the header cell and type the new name. Your data stays the same — only the label changes. If you have used that header name in formulas, the formulas still work.

Do headers affect sorting and filtering?

When you use the filter feature, Google Sheets automatically recognizes your header row and does not include it in the sort. If you sort without using the filter feature, make sure to select only your data rows, not the header, so the header stays at the top.

Can I format my header row differently from the data rows?

Yes. Select your header row, then use the toolbar to change the text color, background color, or font. Many people make headers bold or use a light background color to make them stand out from the data below.

What happens to my header if I delete a row of data?

Your header stays in place. Deleting data rows does not affect row 1. Only delete the header row itself if you want to remove it, which you would do by right-clicking row 1 and selecting "Delete row".