Combine Cells in Excel for a Title: Step-by-Step

How-to basics · Updated November 18, 2026

To combine cells for a title in Excel for Microsoft 365 on Windows, enter the title in the leftmost cell of the row, select the cells it should span, then choose Home > Merge & Center. This merges the selected cells and centers the title. Before merging, make sure the other selected cells are empty: Excel keeps the contents of only the upper-left cell and discards contents in the rest.

Merging can make a heading stand out across several columns, but it changes the worksheet layout. If you need to sort, filter, or work with the columns underneath, consider centering the title across the cells without merging them. The steps below explain both the standard approach and useful alternatives.

What You’ll Need

  • An Excel workbook open in Microsoft Excel for Microsoft 365 on Windows.
  • A blank row above the data, or another row where you want the title to appear.
  • The title text, and an idea of how many columns it should span. For example, a table with data in columns A through F could have a title spanning A1:F1.

Step-by-Step

  1. Choose a row for the title. Look at the width of the table or report the title belongs to. If your data uses columns A through F, a title in row 1 could span A1:F1. Leave the row directly above the table clear if you want more space between the heading and the column labels. Avoid putting the title inside the data rows, where it could interfere with sorting and filtering.
  2. Enter the title in the leftmost cell. Click A1 in the example and type the full heading, then press Enter. When Excel merges a range, it retains the value in the upper-left cell of that range. For a horizontal range such as A1:F1, that is A1. If the title is already in another cell within the range, move or copy it to A1 before merging.
  3. Select the cells the title should span. Click A1, hold the mouse button, and drag across to F1. You can also click A1, hold Shift, and click F1. Check that the selection covers exactly one row and the intended columns. If the table starts in B and ends in G, for example, select B1:G1 rather than A1:F1.
  4. Merge and center the selection. On the ribbon, open the Home tab and click Merge & Center in the Alignment group. The cells become one wider cell, and the title is centered across the merged area. If Excel displays a warning that only the upper-left value will be kept, read it carefully: choose OK only if the other selected cells do not contain information you need.
  5. Check the result and adjust the title row. Confirm that the title is centered above the right columns and that no text is clipped. If the heading wraps, select the merged cell and use Home > Wrap Text, or increase the row height by dragging the boundary below the row number. You can adjust the font, size, bold formatting, fill color, and borders from the Home tab.
  6. Use another merge option only when it fits the layout. The arrow beside Merge & Center opens options including Merge Cells, which merges without centering, and Merge Across, which merges cells separately across each row of a multirow selection. For one title spanning a single row, Merge & Center is usually the straightforward choice. Do not choose Merge Across for a multirow title range unless you really want a separate merged area on every row.
  7. Save and test the worksheet layout. Save the workbook, then check the heading alongside the table. If you plan to sort or filter the data, test those actions before relying on the layout. Merged cells in or near a data range can make some worksheet operations awkward; a centered, unmerged title is often easier to maintain.

Common Mistakes

Merging cells that already contain several values: Excel does not combine the text from every selected cell into one title. It keeps the upper-left value and removes the contents of the other cells in the selection. A warning may appear, but do not treat merging as a way to join words from separate cells. If you need to preserve those values, cancel the operation and copy them somewhere safe first.

Selecting the wrong range: If the merge is wider than the table, the title may look off-center. If it is narrower, the title may not align with the table edges. Check the column letters and the selection outline before choosing Merge & Center. For a report spanning A:F, A1:F1 is a more suitable title range than A1:D1 or A1:G1.

Merging the data area instead of just the heading: Merging cells within a list can make it harder to sort, filter, select, or copy the records. Keep a merged title in a separate row above the column headers. Avoid merging cells down a column merely to make the worksheet look neater if each row represents an individual record.

Expecting Merge & Center to preserve the original alignment: That command centers the text. If you want the text left-aligned or right-aligned, select the arrow beside the merge button and choose Merge Cells, then set the desired alignment separately using the alignment controls on the Home tab.

Using the wrong merge choice for multiple rows: Merge Across acts row by row. Selecting A1:F2 and choosing it creates a merged range for A1:F1 and another for A2:F2, not one large title cell spanning both rows. For a normal title, select cells in just one row.

Tips

Consider Center Across Selection instead of merging. This displays text centered across a selected range while leaving its cells separate. Select the title cell and the cells it should span, then open Home > Alignment dialog launcher (the small arrow in the lower-right corner of the Alignment group). On the Alignment tab, set Horizontal to Center Across Selection, then click OK. Keep the title in the leftmost cell of the selected range. This option can preserve a more flexible worksheet structure than merging, though the text is still stored in just one cell.

Use a clear visual hierarchy. A title usually needs to be more prominent than the column headers, not dramatically larger than the rest of the sheet. Try bold text and a modestly larger font, then add a subtle fill or bottom border if it helps distinguish the heading. Keep enough contrast between the text and background so the title stays readable when printed.

Make long titles fit deliberately. If a title runs beyond the width of the table, consider shortening it, wrapping it onto a second line, or widening the relevant columns. A taller title row can work, but allow for the extra space when printing. Do not shrink the font so far that the heading becomes difficult to read.

Keep a backup of important cell contents. Before merging a range that might contain data, copy the contents to a temporary location or save a separate workbook copy. Excel’s warning is a useful reminder, but a backup makes recovery easier if the wrong range was selected.

Remember that a merged range has one usable cell. After merging A1:F1, Excel treats the merged area as a single cell for many editing tasks, and its address is A1. Formulas and references should use the upper-left address. If you later unmerge the range, the title remains in A1; the other cells return as separate blank cells.

Troubleshooting

The merge button is unavailable: Check whether you are editing a cell. Press Enter or Esc to finish editing, then select the range again. Also check whether the worksheet is protected, or whether the selected cells are inside an Excel table. Merged cells are not supported within a table’s data area. If necessary, move the title above the table or convert the table to a normal range using the table tools, after considering what features you would lose.

Excel says it will keep only the upper-left value: That warning means another selected cell contains something. Choose Cancel if you are unsure. Inspect the range, move any needed contents elsewhere, and try again only when the selection is safe to merge. If the goal is to join text from multiple cells, combine the text in a separate cell first rather than merging the source cells.

The title appears off-center: Check that the range starts and ends at the same columns as the report. A title can be centered correctly within its merged range and still look misplaced if that range does not match the table width. Also check for hidden columns or unusual column widths, which can affect the visual center.

The title is cut off or row height looks wrong: Select the merged cell and turn on Home > Wrap Text, then adjust the row height. If wrapping does not display as expected, try setting the row height manually by dragging the row boundary. You can also reduce the font size slightly or widen the columns included in the merge.

You cannot sort or filter the list afterward: Look for merged cells within the data range or across the header area. Unmerge them and use ordinary cells for the table headings. Keep any decorative merged title above the table, with a separate row of unmerged column labels beneath it.

You merged the wrong cells: If the action was just performed, press Ctrl+Z on Windows to undo it. On Mac, use Command+Z. Alternatively, select the merged cell and choose Home > Merge & Center > Unmerge Cells. Unmerging restores the separate cells but does not bring back values discarded from the other cells during the merge, so use undo or a backup if information was lost.

Frequently Asked Questions

Does merging cells combine their text?
No. Excel retains the contents of the upper-left cell and discards contents in the other selected cells. To preserve all the text, cancel the merge and combine or move the contents before changing the layout.

How do I center a title across columns without merging?
Enter the title in the leftmost cell, select that cell and the cells across which it should appear, then open the Alignment dialog from Home > Alignment. Set Horizontal to Center Across Selection and click OK. This keeps the cells separate.

Can I merge cells in Excel for the web?
Excel for the web also offers merge controls on the Home tab, though the ribbon layout can vary with the available window width. Select the range and look for Merge & Center or its menu in the Alignment area. The same key caution applies: merging retains only the upper-left cell’s contents.

How do I undo or reverse a merge?
Immediately after merging, press Ctrl+Z on Windows or Command+Z on Mac. Later, select the merged cell and use Home > Merge & Center > Unmerge Cells. Unmerging separates the range but does not restore any contents that were discarded when it was merged.

Will a merged title affect sorting and filtering?
It can if the merged cells overlap the table or its header row. Place the title in its own row above the table, and keep the data area and column headings unmerged. For the most flexible layout, use Center Across Selection for the title instead.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.