How to Make an Excel Header Span Multiple Columns

To center a title over several columns in Excel without merging, type it in the leftmost cell, select it and the cells to its right, open Format Cells > Alignment and set Horizontal to Center Across Selection. Merge & Center on the Home tab looks the same but joins the cells, which can cause trouble when sorting or copying.

You typed a report title in A1 and it sits in one narrow column while the table below stretches across six.

Which Kind of Header Do You Need?

“Header” means different things in Excel. Pick the row that matches what you want, then jump to that section.

What you wantBest tool
A title centered above several columns of dataCenter Across Selection (or Merge & Center)
Text at the top of every printed page, like a company name or dateHeader & Footer
The column labels row printed on every pagePrint Titles
The column labels row visible while you scrollFreeze Panes
Column labels that stay with the data when you sort and filterFormat as a table

Center a Title Across Columns Without Merging

Center Across Selection is a horizontal alignment option. Microsoft describes it as centering a cell entry across the selected cells. The text displays centered over the whole range, but every cell stays a separate cell, so nothing in your sheet behaves differently.

Excel Format Cells dialog with Center Across Selection selected
Center Across Selection lives in the Horizontal list on the Alignment tab. (Recreated interface)

Example: Omar’s sales sheet has data in columns A through F, starting in row 3. He wants “Q3 Regional Sales” centered above it in row 1.

  1. Type the title in the leftmost cell of the row, A1 in this example.
  2. Make sure the other cells in that row (B1 to F1) are empty. Any text there stops the title from spreading into those cells.
  3. Select A1 through F1.
  4. Right-click the selection and choose Format Cells.
  5. Open the Alignment tab.
  6. Under Text alignment, open the Horizontal list and choose Center Across Selection.
  7. Select OK. The title now sits centered over columns A to F.

To check it worked, click B1: the formula bar is empty, because the text still lives in A1. To undo it, select the same cells, open Format Cells again, and set Horizontal back to General.

Why prefer it? Merged cells are a common cause of trouble later: you can’t always select a single column cleanly, pasting into a range that contains merged cells can fail, and sorting a range with merged cells of different sizes may be refused. Center Across Selection avoids all of that because no cells are joined. Microsoft lists the option on the Alignment tab of the Format Cells dialog in its reference for Format Cells settings.

Use Merge & Center for a Single Wide Cell

Merge & Center joins the selected cells into one large cell and centers the text in it. It’s the familiar route, and fine for a title that sits above the data and is never sorted or filtered.

Merge and Center menu on the Excel Home tab
The down arrow holds Merge Across and Unmerge Cells. (Recreated interface)

Warning: when cells merge, Excel keeps only the content of the upper-left cell. Anything typed in the other cells is deleted. Put the title in the leftmost cell, and clear or move anything else in the row before you merge.

  1. Type the title in the leftmost cell.
  2. Select that cell and the cells to its right that the title should cover.
  3. On the Home tab, select Merge & Center.
  4. Format the merged cell as needed (bold, larger font, fill color).

The down arrow next to Merge & Center has other choices. Merge Across merges each selected row separately, which is useful when you have several stacked title rows, and Merge Cells joins cells without centering. To reverse a merge, select the merged cell, open the same down arrow and choose Unmerge Cells; the text returns to the upper-left cell. Microsoft’s page on merging and unmerging cells has the steps for Windows, Mac and the web, and how to merge cells in Excel covers more merging situations.

Add a Header to the Printed Page

If “header” means text that prints at the top of every page, outside the grid, use Excel’s page header. It has three sections (left, center and right), so a centered page header spans the full width of the page no matter how many columns you print. The same Page Setup dialog can also put a footer on every sheet in a workbook when the sheets are grouped.

  1. Select Insert > Header & Footer. Excel switches to Page Layout view.
  2. Click the left, center or right header box at the top of the page.
  3. Type the header text, or use the Header & Footer tab that appears on the ribbon (called Design in some versions) to add items such as the page number or date.
  4. Click any cell in the sheet, then switch back with View > Normal or the Normal button on the status bar.

An alternative route: on the Page Layout tab, select the Page Setup dialog launcher (the small arrow in the group’s corner), open the Header/Footer tab, select Custom Header and type in the Left, Center or Right section. Microsoft’s guide to headers and footers in a worksheet covers both routes. Page headers don’t appear in Normal view, so switch to Page Layout view or check the print preview to see them.

Repeat the Header Row on Every Printed Page

Long tables print over several pages, and by page two nobody knows which column is which. Print Titles fixes that by printing your labels row at the top of each page.

Excel Page Setup with rows to repeat at top
Rows to repeat at top prints the labels row on every page. (Recreated interface)
  1. On the Page Layout tab, select Print Titles.
  2. Click in Rows to repeat at top, then click the row number of your labels row in the sheet. Excel fills in a reference such as $3:$3. To repeat both a title row and a labels row, select both, for example $1:$3.
  3. Select OK, then check File > Print to see the row on page two.

If Print Titles is dimmed, you’re probably still editing a cell or have a chart selected on the sheet; press Enter or Esc and click a cell. It is also dimmed if no printer is installed on the PC. Details are on Microsoft’s page about repeating rows on every printed page.

Keep the Header Row Visible While You Scroll

On screen, Freeze Panes keeps the title and labels rows in place while the data scrolls under them.

  1. Click the cell just below the last row you want to keep, in column A. For Omar’s sheet with labels in row 3, that’s A4.
  2. On the View tab, select Freeze Panes, then Freeze Panes.
  3. Scroll down to check that rows 1 to 3 stay put.

Excel freezes the rows above and the columns to the left of the cell you select, which is why column A matters. To release them, choose View > Freeze Panes > Unfreeze Panes. There’s more on this in freezing panes in Excel.

If your labels row sits directly above the data, you can also format the range as an Excel table (Insert > Table, and keep My table has headers selected). The first row becomes a header row, and you can turn it on or off later from Table Design > Header Row. Microsoft notes in its page on table headers that a table header row is separate from a printed page header.

Excel for the Web and Mac

Merge & Center and Unmerge Cells work in Excel for Windows, Mac and the web; Microsoft’s merge page has a tab for each. On a Mac, look for Format Cells on the right-click menu or the Format menu; the Alignment tab should look much like the Windows version. Excel for the web has a more limited formatting dialog, and Microsoft’s pages don’t confirm whether it offers Center Across Selection. If you can’t find it there, apply it in the desktop app instead.

Troubleshooting Header Problems in Excel

Excel won’t sort my data after I merged the title.

Sorting runs into trouble when the selected range includes merged cells. Select only the data (labels row and below) before sorting, or replace the merge with Center Across Selection: unmerge the title, then apply the alignment as described above.

My title disappeared after merging.

It was probably in a cell other than the upper-left one, and Excel deleted it during the merge. Press Ctrl+Z right away to undo, move the text into the leftmost cell, and merge again.

Center Across Selection doesn’t center my text.

Check that the text is in the leftmost cell and that the cells to its right are truly empty. Even a space typed into one of them blocks the spread. Select the cells and press Delete to clear them, then check again.

How do I stop people from changing the title?

Protect the sheet while leaving the data cells editable. The steps are in locking cells in Excel.

Where to Go From Here

For a title over your data, use Center Across Selection first and keep Merge & Center for layouts that will never be sorted. Then, if the sheet will be printed, add Print Titles so the labels row appears on every page, and freeze the top rows so they stay visible while you work.