Merging cells changes worksheet layout, not the underlying meaning of several values. Before selecting Merge & Center, check which cells contain data because Excel keeps only one cell's content in the merged result.
Merge cells in Excel
- Select the adjacent cells that should become one display area.
- Open the Home tab and find the Alignment group.
- Open the arrow beside Merge & Center.
- Choose Merge & Center, Merge Across, or Merge Cells according to the layout you need.
- Save a copy and check formulas, sorting, filtering, and screen-reader navigation around the merged range.
Microsoft's current merge and unmerge cells documentation warns that only the upper-left cell's content is retained in left-to-right worksheets. Move or combine the other values before merging.
Merge & Center versus Merge Cells
Merge & Center creates one larger cell and centers the retained content. Merge Cells creates the merged area without forcing centered alignment. Merge Across can merge each row in a selected multi-row range separately. The exact menu can vary slightly between desktop, Mac, mobile, and Excel for the web, so use the options shown in your version.
Merged cells are most appropriate for a heading that spans several columns. They can complicate sorting, filtering, copying, keyboard navigation, formulas, and data imports when used inside the main data table.
Unmerge cells
Select the merged cell, open the Merge & Center menu, and choose Unmerge Cells. Immediately after a merge, Undo is another option. Unmerging does not restore values that were discarded during the original merge. Restore those values from Undo history, another copy, version history, or a backup when available.
Combine cell values without merging the layout
If the goal is to join a first name and last name, address fields, codes, or other values, use a formula instead of merging cells. For example, =A2&" "&B2 inserts a space between two values. =CONCAT(A2," ",B2) provides a similar result, while TEXTJOIN is useful when several cells need one delimiter and blank values should be handled deliberately.
Keep the original columns until the combined output has been checked. Copying the formula result and pasting values can create a fixed column when the source cells will no longer change.
Do not confuse cells, columns, sheets, and files
Merging cells changes a selected worksheet range. Combining columns joins or aligns data fields. Merging sheets or workbooks brings larger data sets together. The ToolZone Excel Merger combines uploaded XLSX, XLS, or CSV files as separate sheets or appends compatible rows into one sheet; it does not edit merged-cell formatting, concatenate columns, perform key-based joins, or reconcile formulas.
Safe worksheet checklist
- Keep a backup before changing a large or shared workbook.
- Confirm that only the intended retained cell contains data.
- Avoid merged cells inside sortable data tables.
- Test printing, filters, formulas, copy and paste, and accessibility.
- Document whether the task is visual merging or data combination.