The fastest way to change a header in Excel

To change a header in Excel, click the cell containing the header text, type the new text, and press Enter. That is the basic move — it works the same way as editing any other cell. If you want to change the header row itself (swap which row acts as the header), you use the Data menu to tell Excel which row to treat as headers.

The method depends on what you are actually changing. If you just need different words in the top row, edit the cells directly. If you need to move the header to a different row, or if you are working with a table that has formatting applied, the steps are slightly different.

Key Takeaways

  • Click any header cell, type new text, and press Enter to change what the header says.
  • To move the header row to a different position, select your data range, go to Data > Table Design (or Data > Define Name), and specify which row contains headers.
  • If your data is formatted as an Excel table, right-click the table and choose Table Design to access header options without losing formatting.
  • Header rows stay in place when you sort or filter — they do not move with the data — so changing them does not affect your sort order.

Editing header text directly

Click the cell that contains the header you want to change. Type the new text. Press Enter. The old text disappears and the new text takes its place. This works whether the header is in row 1, row 2, or anywhere else on the sheet.

If you want to edit only part of the text — change "Sales Total" to "Total Sales" without retyping the whole thing — double-click the cell to enter edit mode, then use your arrow keys and backspace to make the change. Press Enter when you are done.

Changing which row Excel treats as the header

By default, Excel assumes row 1 is your header row. If your actual headers are in row 2, or if you want to remove headers entirely, you need to tell Excel which row to use. Select your entire data range first — click the top-left cell of your data and drag to the bottom-right, or click the top-left cell and press Ctrl+Shift+End.

Go to the Data menu at the top. Look for Table Design or Define Name depending on your Excel version. A dialog box opens. Check the box that says "My data has headers" if your data does have headers, or uncheck it if it does not. Click OK. Excel now knows which row is the header.

If you are using Excel on a Mac, the menu path is slightly different: go to Data, then look for Create Table or Format as Table. The same checkbox appears in the dialog that opens.

Changing headers in a formatted table

If your data is already formatted as an Excel table (you can tell by the colored row at the top and the filter buttons next to each header), changing the header is even simpler. Click any cell in the table. The Table Design tab appears in the ribbon at the top. Click it.

In the Table Design tab, look for Header Row in the Table Style Options section. Check or uncheck this box to show or hide the header row. If the header row is visible and you just want to change the text, click the header cell and edit it the same way you would edit any other cell.

If you want to change the header row to a different row, you will need to convert the table back to a regular range first. Right-click the table, select Convert to Range, then follow the steps in the section above to specify which row is the header.

Keeping headers visible when you scroll

If your spreadsheet has many rows, you may want to keep the header row visible at the top even when you scroll down. Click the cell directly below the header row — if headers are in row 1, click cell A2. Go to the View menu and select Freeze Panes. The header row now stays at the top no matter how far down you scroll.

To unfreeze, go back to View and select Freeze Panes again. The checkmark disappears and the panes unfreeze.

Renaming multiple headers at once

If you need to change several headers, you can do it one at a time by clicking each cell and typing, but there is no faster built-in way to rename them all in a single step. However, you can select the entire header row and use Find & Replace to change text patterns. Press Ctrl+H to open Find & Replace, type the text you want to find, type the replacement text, and click Replace All.

Be careful with Find & Replace on headers — if you search for a word that appears elsewhere in your data, it will change those cells too. To limit the change to headers only, select just the header row before opening Find & Replace.

Headers and sorting or filtering

When you sort or filter your data, the header row does not move with the data — it stays at the top. This is why telling Excel which row is the header matters. If Excel does not know row 1 is a header, it will treat it as data and sort it along with everything else, which usually scrambles your headers into the middle of your results.

If this happens, undo the sort (Ctrl+Z), specify the header row correctly using the Data menu, and sort again. The header will stay in place this time.

Frequently Asked Questions

Can I have headers in more than one row?

Excel treats only one row as the header row for sorting and filtering purposes. If you need multiple rows of labels, format them as regular data rows and leave them above the actual header row, or use merged cells in a single row to create a multi-line header.

What happens if I delete a header cell?

The cell becomes empty, but the row is still treated as a header row. If you want to remove the header row entirely, go to Data > Table Design, uncheck "My data has headers", and click OK. The formatting will change but the row will remain on the sheet.

Can I change the header formatting without changing the text?

Yes. Click the header cell, then use the formatting tools in the Home tab — font, size, color, bold, italic, background color. Changes to formatting do not affect the text itself or how Excel treats the header row.

How do I add a header row to data that does not have one?

Right-click row 1 and select Insert to add a blank row at the top. Type your headers in this new row. Then select your data range and use Data > Table Design to tell Excel that row 1 now contains headers.

Does changing a header affect formulas that reference it?

If your formulas use the header text directly (like =SUM(Sales)), changing the header text will break the formula. If your formulas reference the cell address (like =SUM(A:A)), changing the header text has no effect on the formula.