How to Merge Cells in Excel
Merge cells in Excel when a title or section header needs to span columns. Learn when to merge, when not to, and safer alternatives for working sheets.
Merging cells in Excel turns two or more selected cells into one larger cell. It is useful for report titles, section headers, and printable layouts, but it can damage sorting, filtering, formulas, and copy-paste behavior if you use it inside working data.
Use merged cells for presentation areas. Avoid them in tables where each row and column needs to behave predictably.
How to merge cells
Step 1. Select the cells you want to merge, such as A1:F1.
Step 2. Go to the Home tab.
Step 3. Click Merge & Center if the text should be centered across the selected range.
Step 4. Use the dropdown next to Merge & Center if you need a different option:
Merge & Centercombines the cells and centers the content.Merge Acrossmerges cells across each selected row.Merge Cellscombines the cells without centering.Unmerge Cellsrestores the original cell grid.
Excel keeps the upper-left value and discards values in the other selected cells.
WATCH OUT
Use Center Across Selection instead
For many spreadsheet headers, Center Across Selection is safer than merging. It makes text appear centered across columns while keeping the cells separate.
Step 1. Select the header range, such as A1:F1.
Step 2. Open Format Cells.
Step 3. Choose the Alignment tab.
Step 4. Set Horizontal to Center Across Selection.
This keeps sorting, filtering, column resizing, and formulas easier to manage.
Where merged cells cause problems
Merged cells become risky when they sit inside operating tables. A project tracker with merged owner or status cells will be harder to sort. An employee schedule with merged shift blocks can break filtering by role. A budget tracker with merged category labels can make formulas harder to audit.
| Problem | Why it happens | Better option |
|---|---|---|
| Sorting fails | Excel cannot treat merged rows consistently | Keep one value per row |
| Filters behave oddly | Merged cells span records | Repeat the label in each row |
| Copy-paste breaks layout | Merged areas do not match normal cells | Use formatting instead |
| Formulas are harder to read | References point to only one merged cell | Use helper labels or headings |
When merging is fine
Merged cells are fine for titles, printable invoice headers, dashboard labels, and section dividers that are outside the data table. They work well in a client-facing invoice template or a polished report cover area.
The rule is simple: merge for presentation, not for data structure.
The Griddy way
Merged cells are easy to add manually, but they are also easy to put in the wrong part of the sheet.
"Make the report title span the whole table, but keep the data rows sortable and filterable"
Griddy can format the header area while preserving the underlying grid where formulas, filters, and review workflows need normal cells.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.