The fastest way to change a header in Excel
To change a header in Excel, click the cell containing the header text, type your new text, and press Enter. That is the complete process for a single header cell. If you want to change the entire header row at once — or format headers so they stand out — you have a few more options depending on what you are trying to do.
Headers in Excel are just regular cells in the top row of your data. Excel does not treat them differently unless you tell it to. This means you can edit them the same way you edit any other cell: click it, type, and move on.
Key Takeaways
- Click any header cell, type your new text, and press Enter to change it when ready.
- Use the Format as Table feature to make headers bold and add a filter dropdown automatically.
- The Header Row checkbox in the Table Design tab tells Excel which row contains your headers so filters and sorting work correctly.
- If your headers span multiple rows or columns, you can merge cells first, then add your text.
- Changing a header does not affect the data below it unless you use a formula that references the header by name.
Editing a single header cell
Click the cell at the top of the column you want to rename. The cell reference box (showing something like "A1") appears in the top left. Type your new header text directly into the cell or into the formula bar above the spreadsheet. As you type, you will see the text appear both in the cell and in the formula bar.
Press Enter when you are done typing. Excel moves to the cell below and saves your change. If you want to stay in the same cell and move to the next one horizontally instead, press Tab. To cancel your edit without saving, press Escape.
If the header text is too long to fit in the column width, the text will either overflow into the next cell (if that cell is empty) or get cut off visually. The full text is still there — you just cannot see it all. To see the entire header, widen the column by double-clicking the border between column letters at the top, or drag the border to the right.
Changing multiple headers at once using Format as Table
If you want to change the appearance of your headers and add filtering at the same time, use the Format as Table feature. First, click any cell in your data range, including a header cell. Then go to the Home tab and click Format as Table. Choose a style from the gallery that appears.
Excel will show a dialog asking you to confirm the data range. Make sure the range includes all your data and that the "My table has headers" checkbox is checked. Click OK. Excel now treats your top row as a header row, makes it bold and colored, and adds a dropdown arrow to each header cell so you can sort and filter.
You can still edit the header text the same way — click the cell and type. The formatting stays in place. If you want to change the header style later, click any cell in the table, go to the Table Design tab, and choose a different style from the gallery.
Telling Excel which row is your header row
If you have already formatted your data as a table but Excel is not treating the top row as headers, check the Table Design tab. Look for the Header Row checkbox on the left side of the ribbon. If it is unchecked, click it to turn it on. Excel will now format the top row as a header and add filter dropdowns.
This is useful if you imported data from another source and the headers were not recognized, or if you created a table without headers and added them later. Once the Header Row checkbox is on, you can edit the headers normally, and Excel will remember that row as your header row for sorting, filtering, and formulas.
Changing headers that span multiple columns or rows
If you want a single header to span across multiple columns — for example, a title that covers several related columns — you can merge cells first. Select the cells you want to merge by clicking the first cell and dragging to the last one. Then go to the Home tab, click the Merge & Center button (or the dropdown next to it), and choose Merge Cells.
Type your header text into the merged cell. The text will be centered across all the merged cells. If you later need to unmerge the cells, select the merged cell, go to Home, click Merge & Center, and choose Unmerge Cells. The text will stay in the first cell of the range.
Be aware that merged header cells can cause problems with sorting and filtering in some cases. If you plan to use those features heavily, it is often better to keep headers in single cells and use formatting (bold, color, larger font) to make them stand out instead.
Using named ranges to reference headers in formulas
If you use formulas that reference your headers by name — for example, a SUMIF formula that looks for a column called "Sales" — changing the header text will break the formula. Excel does not automatically update the formula to match the new header name.
To avoid this problem, use named ranges. Select the data in a column (not including the header), go to the Formulas tab, and click Define Name. Give the range a name that matches your header, like "Sales". Now your formulas can reference that named range instead of a cell address, and changing the header text will not affect the formula.
Alternatively, use the INDIRECT function in your formula to reference the header cell itself. This way, if you change the header text, the formula updates automatically because it is reading the cell content, not a fixed reference.
Formatting headers to make them stand out
Once you have changed your header text, you can format it to make it visually distinct from the data below. Select your header row by clicking the row number on the left side. Then use the formatting tools on the Home tab: click Bold to make the text thicker, use the Font Color dropdown to change text color, or use the Fill Color dropdown to add a background color.
You can also increase the font size, change the font type, or add borders. Select the header cells, then use the Border dropdown to add a line below the headers to separate them from the data. These formatting changes do not affect how Excel sorts or filters your data — they are purely visual.
Frequently Asked Questions
Can I undo a header change?
Yes. Press Ctrl+Z (or Cmd+Z on Mac) when ready after making the change, or go to the File menu and click Undo. You can undo multiple changes by pressing Ctrl+Z repeatedly. If you have already saved the file, you cannot undo changes from before the save.
What happens to my data if I change a header?
Changing a header does not affect the data in the cells below it. The data stays exactly where it is. If you have formulas that reference the header cell by its address (like A1), those formulas will still work. If you have formulas that reference the header by name, you may need to update them.
Can I change headers in a protected sheet?
If the sheet is protected, you may not be able to edit any cells, including headers. Go to the Review tab and click Unprotect Sheet. If the sheet is password-protected, you will need the password. Once unprotected, you can change headers normally.
How do I add a header row if my data does not have one?
Right-click the row number 1 at the top left and select Insert to add a blank row above your data. Type your headers into this new row. Then select any cell in your data and use Format as Table to tell Excel that row 1 is your header row.
What is the difference between a header and a title?
A header is the label for a column of data, usually in the first row. A title is a label for the entire spreadsheet, usually placed above the data. Titles are not part of the data table itself and do not affect sorting or filtering. Headers are part of your data range and do affect how Excel treats the columns.