How to Merge Cells, Columns & Rows in Excel

Merging cells, columns, or rows in Excel combines multiple adjacent cells into one larger cell, which is useful for creating headers, grouping labels, or improving the layout of a spreadsheet. This guide shows you the exact steps for merging and unmerging in current versions of Excel (2016, 2019, 2021, and Microsoft 365). You only need the Excel file you want to edit and a mouse or trackpad.

What You’ll Need

• Microsoft Excel installed on your computer (Windows or Mac).
• An existing spreadsheet or a new blank workbook.
• Data you want to merge, or a clear idea of where you want merged cells.

Step-by-Step

1. Open your Excel file – Double-click the file to open it in Excel. If you’re starting fresh, open a blank workbook.
2. Select the cells you want to merge – Click and drag your mouse across the cells you want to combine. They must be adjacent (next to each other) in a rectangle. For example, to merge A1, B1, and C1, click on A1, hold the mouse button, drag to C1, and release.
3. Go to the Home tab – Look at the top ribbon. Click on the “Home” tab if it isn’t already selected.
4. Find the Merge & Center button – In the “Alignment” group (usually in the middle of the ribbon), you’ll see a button labeled “Merge & Center” with an icon of two boxes merging.
5. Click the Merge & Center button – This merges the selected cells into one and centers the text. If you don’t want the text centered, click the small arrow next to the button and choose “Merge Across” (for rows) or “Merge Cells” (to merge without centering).
6. Merge entire columns or rows – To merge a whole column, select the column letter (e.g., click “A”) to highlight the entire column, then repeat steps 3–5. To merge a whole row, click the row number (e.g., “1”) to highlight it, then merge. Note that merging an entire column will combine every cell in that column into one long cell, which is rarely useful; usually you merge a range within a column.
7. Merge multiple rows or columns at once – Select a rectangular range that spans multiple rows and columns (e.g., A1:C2), then click “Merge & Center”. This creates a single cell covering all selected cells.
8. Unmerge cells – If you need to undo a merge, select the merged cell, click the arrow next to “Merge & Center”, and choose “Unmerge Cells”. The original data will return, but only the top-left value is kept; other values are lost.

Common Mistakes

• Losing data – When you merge cells, Excel keeps only the upper-left value and discards the rest. Always copy important data elsewhere before merging.
• Merging non-adjacent cells – Excel only allows merging a contiguous rectangle. You cannot merge cells that are not next to each other.
• Merging entire columns or rows by accident – Clicking a column letter selects the whole column, which could merge thousands of cells. Use the mouse to drag over only the range you need.
• Sorting or filtering breaks – Merged cells can cause problems with sorting, filtering, and pivot tables. Avoid merging in data tables that you plan to filter or sort.

Tips

• Use “Merge Across” for row headers – If you have multiple rows of headers, “Merge Across” merges each row separately without merging columns, which is often more useful.
• Keyboard shortcut – On Windows, press Alt + H + M + C to merge and center. On Mac, use Cmd + M (but check your version).
• Merge for printing – Merging cells can make a spreadsheet look cleaner when printed, especially for titles.
• Use Center Across Selection instead – If you only want text centered across cells without actually merging (to avoid data loss), select the cells, right-click, choose “Format Cells”, go to the “Alignment” tab, and under “Horizontal”, select “Center Across Selection”. This visually centers text but keeps cells independent.

Troubleshooting

• Merge button is grayed out – This happens when the sheet is protected or cells are in a table. Unprotect the sheet (Review tab > Unprotect Sheet) or convert the table to a range (Table Design tab > Convert to Range).
• Cannot merge cells in a table – Excel tables don’t support merged cells. Convert the table to a normal range first, then merge.
• Data disappears after merging – As noted, only the top-left value is kept. Use Undo (Ctrl+Z) immediately to restore, then copy the data you need before merging again.
• Merged cell won’t sort or filter – This is a known limitation. Unmerge the cells and use “Center Across Selection” instead if you need sorting/filtering.
• Merged cells not printing correctly – Adjust the page setup or check print preview. Sometimes merged cells split across pages; set the print area to avoid this.

Frequently Asked Questions

Can I merge cells without losing data?

No, Excel only keeps the upper-left value. To avoid loss, copy the other values to a different location before merging, or use “Center Across Selection” which doesn’t actually merge.

How do I merge a column of cells vertically?

Select the vertical range (e.g., A1:A5) and click “Merge & Center”. This combines them into one tall cell.

Can I merge cells in Excel Online?

Yes, Excel for the web supports merging. Select the cells, go to the Home tab, and click the Merge & Center button. The options are slightly limited but include Merge & Center, Merge Across, and Unmerge.

What’s the difference between “Merge & Center” and “Merge Cells”?

“Merge & Center” merges and centers the text. “Merge Cells” merges but keeps the text left-aligned (or as it was). Both keep only the top-left value.

Why can’t I merge cells in a protected sheet?

Merging is not allowed if the sheet is protected. Go to Review > Unprotect Sheet (enter password if needed) to enable merging.

How do I merge cells in a pivot table?

Pivot tables don’t allow merging. You can copy the pivot table and paste as values, then merge the copied cells, but you’ll lose the pivot functionality.

Related

• Convertible Bonds: Impact on Debt and Share Count
• Python vs SQL: Key Differences Explained
• Fix Chrome Lagging or Slow Opening Issues