To merge cells in Excel, follow these steps:
- Select the cells you want to merge
Click and drag to highlight two or more adjacent cells you want to combine. Make sure the data you want to keep is in the upper-left cell because merging will keep only that cell's content and delete data in the other selected cells
- Use the Merge command
- Go to the Home tab on the ribbon.
- In the Alignment group, click the drop-down arrow next to Merge & Center.
- Choose one of the following options:
- Merge & Center: merges the cells and centers the content.
- Merge Across: merges cells horizontally in each row separately.
- Merge Cells: merges the cells without centering the content
- Keyboard shortcuts (Windows)
- To merge cells: press ALT + H + M + M.
- To merge and center: press ALT + H + M + C.
- To merge across: press ALT + H + M + A.
- To unmerge cells: press ALT + H + M + U
- Unmerge cells if needed
Select the merged cell, then click Merge & Center again and choose Unmerge Cells. Note that unmerging will not restore deleted content from other merged cells
Important: If the Merge options are disabled, ensure you are not editing a cell and that the cells are not part of an Excel table, as tables do not support merging cells
. This process allows you to create larger cells for titles or formatting purposes in your worksheet efficiently.
