Add a header row by typing labels in the first row of your spreadsheet

A header row in Excel is simply the first row of your spreadsheet where you type column labels — like "Name," "Email," or "Date." Excel does not create headers automatically. You type them yourself into cells A1, B1, C1, and so on, then format them to stand out from the data below.

Headers help you and anyone else reading the spreadsheet understand what each column contains. They also make sorting and filtering easier, because Excel recognizes headers and can use them as reference points when you rearrange data.

Key Takeaways

  • Type your column labels directly into the first row of cells, starting with A1, and move across to the right.
  • Use the Format as Table feature to automatically format headers with a background color and bold text, which also locks them in place when you scroll.
  • Freeze the header row so it stays visible when you scroll down through your data by selecting row 2 and clicking Freeze Panes.
  • Headers make sorting and filtering work correctly, because Excel uses them to identify what each column represents.

Type headers directly into the first row

Click on cell A1 — the box in the top-left corner of your spreadsheet. Type your first column label, such as "Name" or "Product." Press Tab to move to cell B1, and type your next label. Keep pressing Tab and typing until you have entered all your column headers across the first row.

Once you finish typing your last header, press Enter. Your headers are now in place, and you can start entering data in row 2 below them. The headers remain as plain text until you format them, which is the next step.

Format headers to make them visually distinct

Select your entire header row by clicking on the row number "1" on the left side of the spreadsheet. The whole row highlights in blue. Now go to the Home tab at the top and look for the "Format as Table" button in the Styles section. Click it and choose a table style — any option will add a background color and bold text to your headers automatically.

If you prefer to format manually instead, you can select just the cells with headers (A1 through your last column), then click the Bold button (B) on the Home tab and choose a background color from the Fill Color dropdown. This gives you more control over the appearance.

Freeze the header row so it stays visible when scrolling

When your spreadsheet has many rows of data, you will scroll down to see more entries. Without freezing, your headers scroll out of view and you lose track of what each column means. To prevent this, click on any cell in row 2 (the first row of actual data), then go to the View tab at the top and click "Freeze Panes." Choose "Freeze Panes" from the dropdown.

Now when you scroll down, row 1 stays fixed at the top of your screen. You can scroll through hundreds of rows and always see your headers. To unfreeze later, go back to View and click Freeze Panes again, then select "Unfreeze Panes."

Use headers with sorting and filtering

Once you have headers in place, Excel recognizes them when you use the sort and filter features. Select any cell in your data range, then go to the Data tab and click "Filter." Small dropdown arrows appear in each header cell. Click an arrow to sort that column alphabetically, numerically, or by date, or to show only rows that match certain criteria.

Without headers, Excel treats the first row as data and sorts it along with everything else, which scrambles your labels. Headers prevent this mistake and make your data much easier to organize and search through.

Repeat headers on every printed page

If you plan to print your spreadsheet and it spans multiple pages, you can set Excel to print your header row at the top of each page. Go to the Page Layout tab, click "Print Titles," and in the dialog box that opens, click in the "Rows to repeat at top" field. Then click on row 1 in your spreadsheet to select it. Click OK, and your headers will now appear on every printed page.

This is especially useful for long lists or reports that people will read on paper. Without this setting, only the first page shows headers, and subsequent pages are confusing.

Frequently Asked Questions

Can I have more than one header row?

Yes. You can use rows 1 and 2 as headers if you want a title row above your column labels. Just remember to freeze both rows together: click on row 3, go to View, and click Freeze Panes. Both rows will then stay visible when you scroll.

What if I forget to add headers before entering data?

Insert a new row at the top. Right-click on row 1 and select "Insert 1 Row Above." A blank row appears at the top, and all your data shifts down. Now type your headers in this new row 1.

Do headers affect calculations or formulas?

No. Headers are just text in the first row. Formulas and calculations work normally in the rows below. If you reference a column in a formula, use the cell addresses (like A2:A100) rather than the header text, unless you are using a named range or table structure.

How do I remove headers?

Delete the content of row 1 by clicking the row number, pressing Delete, and confirming. If you used Format as Table, the table formatting disappears too. If you froze panes, go to View and click Unfreeze Panes to unlock the rows.