Updated: November 19, 2026

If you need to Google Sheets add header row for a table, the fastest fix is to turn the top line of your data into a labeled row and keep it visible while you work. A good header row makes sorting, filtering, and sharing much easier, and it also helps you find columns at a glance. If the sheet already has headings but they are missing, hidden, or hard to edit, the steps below cover that too.

Create a header row from your first row of data

If your sheet already has column labels in the top row, you do not need a special command to create a header. The first row becomes the header row when you format it clearly and use it as the label row for the rest of the sheet.

  1. Open the sheet and click cell A1.
  2. Type your column names across the top row, one label per column.
  3. Select the header cells in row 1.
  4. Apply bold text from the toolbar.
  5. Center the text if the sheet is cramped, or leave it left aligned for a cleaner table.
  6. Freeze the first row so it stays visible while you scroll.

This is the standard way to make the first row a header in Google Sheets. If your data starts on row 2 or lower, insert a row above it first, then place the labels in row 1.

Insert a new header row above existing data

If your sheet already has data and you want a new header row at the top, insert one row above everything else. This keeps the rest of the data in place and gives you a clean space for labels.

  1. Right click the row number where you want the header to appear.
  2. Choose Insert 1 row above.
  3. Enter the column labels in the new row.
  4. Format the row with bold text and a fill color if you want it to stand out.

If you need a header inside a table that starts lower on the page, insert the row directly above that table. Do not type labels into a random row and hope the sheet treats it as a header, because filters and sorting depend on the row placement and formatting you choose.

Edit an existing header in Google Sheets

If the header is already there, editing it is simple. Click the cell with the label and replace the text with the name you want. For example, change “Name” to “Customer Name” or “Qty” to “Quantity” so the sheet reads clearly.

How to edit header text safely

Edit only the label cells in the header row, not the data underneath them. If you are working with a filter range, changing the header text does not break the filter, but deleting the row can. Keep the row in place and only adjust the words in each column title.

How to change header formatting

Select the header row and use bold, a background fill, or a border to separate it from the body of the sheet. A header row that is visibly different reduces mistakes when you sort, filter, or share the file with other people. If the sheet already uses a style, copy that style across the whole row so the header looks consistent.

Keep the header visible while you scroll

If your main problem is that the header disappears as you move down the sheet, freeze the top row. This is the setting that keeps the header fixed at the top of the screen, so you can always see column names.

  1. Click the row number for row 1.
  2. Open the View menu.
  3. Choose Freeze.
  4. Select 1 row.

After that, row 1 stays visible even when you scroll far down the sheet. If your header starts on row 2 because row 1 holds a title, freeze the rows above your actual header so the header itself remains fixed on screen.

Fix a header that is not showing correctly

When people search for Google Sheets not showing header or Google Sheets header row fixed, the issue is usually one of three things, the header row is hidden, the wrong row is frozen, or the labels are not in the top row of the dataset.

Unhide a hidden header row

If row 1 is missing, look for the small arrows or gap between row numbers. Right click the row numbers around the hidden area and choose to unhide the row. Once it appears again, you can restore the labels and formatting.

Move the header to the top of the range

Filters and sorted data work best when the header is the first row in the selected range. If your labels are lower down, cut that row and paste it above the data block. Then reapply the filter if needed so Sheets recognizes the top row as the header.

Make sure the right row is frozen

If row 1 is frozen but your real header is row 3, Sheets will keep the wrong row visible. Open View and check the freeze setting. Freeze the row that actually contains the labels, not just the top physical row of the sheet.

Use the header row with filters, sorting, and sharing

A proper header row does more than label columns. It makes filters readable, keeps sorts safer, and helps collaborators understand the data fast. When you apply a filter, Google Sheets uses the header names at the top of the selected range as the column labels.

  • Use one unique label per column.
  • Keep header text short and specific.
  • Do not leave blank cells inside the header row.
  • Do not merge header cells unless the layout truly needs it.
  • Keep the header row outside the data range when sorting the table.

If you want the sheet to be easy to read in shared files, use the same label style across every tab. That makes it easier to move between sheets and reduces confusion when someone opens the document for the first time.

Frequently Asked Questions

How do I insert a header in Google Sheets?

Insert a new row above your data, type the column names into that row, then format it with bold text. If you want it visible while scrolling, freeze the top row from the View menu.

How do I make a row a header in Google Sheets?

Put your column names in that row, then format it as the top label row for the sheet. If the data is already below it, keep that row at the top of the range and avoid placing data above it.

How do I keep the header visible in Google Sheets?

Freeze the first row, or freeze the row that contains your labels. Go to View, choose Freeze, then select the row count that matches your header placement.

Why is my Google Sheets header not showing?

The header row is hidden, frozen incorrectly, or placed below the top of the data range. Unhide the row if needed, then move the labels to the correct top row and freeze that row.

How do I edit the header in Google Sheets?

Click the header cell and replace the text. If you want a better visual layout, bold the row and add a fill color so the labels stand out from the rest of the sheet.