How to Merge Cells in Excel: Steps, Options, and Fixes

To merge cells in an XLS workbook in Excel for Microsoft 365 on Windows, select the adjacent cells, then choose Home > Alignment > Merge & Center. Use the button’s dropdown to merge without centering or to merge each row separately. Before you do, check the selection: Excel keeps the value in the upper-left cell and removes other cell contents in the selected range.

“XLS” usually refers to the older Excel 97–2003 workbook format, with the .xls file extension. You can merge cells in this format without converting the file. Merging makes a group of neighboring cells behave like one larger cell, which is useful for a heading spanning several columns. It does not combine the values in those cells, and it can make sorting, filtering, and editing a table harder, so use it mainly for presentation rather than data storage.

What You’ll Need

An XLS workbook opened in Microsoft Excel. If you only have another spreadsheet program, the menu names and behavior may differ.
A saved copy of the workbook, especially if the selected cells contain information you may need later. You can also copy that information to another location before merging.
Adjacent cells in the same worksheet. A single merged area must be a rectangular range; you cannot merge separate, non-adjacent selections in one operation.

Step-by-Step

Open the workbook and locate the cells. In Excel, open the .xls file and go to the worksheet containing the cells. If Excel displays a compatibility notice, you can continue working in the older format; cell merging is available in XLS workbooks. If a message asks whether to enable editing, make sure you trust the file before doing so.
Check what is in the range. Identify the top-left cell of the area you plan to merge. Excel will retain that cell’s value and discard values in the other cells. If the other entries matter, copy them to a safe location first or decide not to merge. For example, if A1 contains “Quarterly sales” and B1 is empty, merging A1:B1 preserves the heading. If B1 contains “North,” that second entry will be removed by the merge.
Select a rectangular range of adjacent cells. Drag across the cells with the mouse, or click the first cell and hold Shift while clicking the last. You can also click the Name Box to the left of the formula bar, type a range such as A1:D1, and press Enter. The example selects four cells across row 1. For a heading over three columns, select only those three cells; do not include unrelated rows or columns.
Open the merge options. On the ribbon, select the Home tab and find the Alignment group. Click the arrow beside Merge & Center to see the available choices. If the ribbon is minimized or the window is narrow, the button may appear as a compact icon; maximize the window or expand the ribbon to find the Alignment group.
Choose the option that fits the layout. Select Merge & Center to create one cell and center its remaining value. Select Merge Cells to create one cell without changing the value’s horizontal alignment. Select Merge Across to merge cells row by row within the selection; for example, selecting A1:C3 creates three separate merged areas, one in each row. Avoid Merge & Center if you do not want centered text, because centering is part of that command.
Review the result. Confirm that the merged area has the intended dimensions, the text is visible, and the remaining value is the one you wanted. If the heading is clipped, select Home > Alignment > Wrap Text or adjust the column width or row height. Wrapping text changes how it displays; it does not restore values removed during merging.
Save the workbook. Press Ctrl+S on Windows and check that the workbook is saved in the intended format. If Excel asks whether to keep the XLS format or convert to a newer format, choose according to the needs of people who will open the file. Saving as XLSX can preserve newer Excel features more reliably, but it is not required just to merge cells.

On Excel for Mac, select the range, open the Home tab, and use Merge & Center or its dropdown in the Alignment group; the button’s position can vary with the ribbon layout. The Windows Ctrl+S save shortcut is Command+S on Mac. In Excel for the web, select the range and look for Merge & Center on the Home tab; the available choices can depend on the current ribbon layout.

Common Mistakes

Merging cells that contain several values. This is the most important risk. Excel does not concatenate the contents: it retains the upper-left entry and removes the others. If you need every value, move or combine the information before merging. A text-joining formula or a manual copy into one cell can preserve the wording, but check the result before replacing the original entries.
Using merged cells in the middle of a data table. A table with one record per row works best when each row has the same independent columns. Merged cells can interfere with sorting, filtering, selecting ranges, and some formulas. Keep headings in a separate area above the data, and leave the actual table cells unmerged.
Selecting too many cells. A selection that spans extra rows or columns can create a much larger merged area than intended. Check the highlighted range or the Name Box before choosing a merge command. If you meant to combine cells in each row separately, choose Merge Across rather than merging the entire selection as one block.
Expecting Merge & Center to combine text. The command changes the cell layout and centers the retained value; it does not join words from multiple cells. Copy any needed content into the upper-left cell first, and inspect it for spacing or missing separators.
Assuming a merged cell is a regular cell for navigation. A merged area can make selecting, pasting, and moving through a worksheet less predictable, particularly when nearby ranges have different shapes. Keep the merged area small and avoid using it where people need to enter or edit individual records.

Tips

Use Merge & Center mainly for headings. A single title above a report or a label spanning a few columns is a good use. For ordinary data, keep one value per cell so the worksheet remains easier to sort, filter, and analyze.
Consider Center Across Selection instead. If you want a heading to appear centered over several columns without physically merging cells, select the cells, open Format Cells from the Home tab’s Alignment options, and choose Center Across Selection in the horizontal alignment list. This keeps the cells separate, which can avoid some merge-related layout problems. The command is not the same as Merge & Center.
Plan the layout before entering data. If a report needs a large heading, set aside a heading row above the main data table. You can merge cells in that row while leaving the records below in a regular grid.
Keep the source values until the result is checked. Before merging a range with content in multiple cells, copy the range to a spare worksheet or another location. That gives you a reference if you later discover that something was omitted.
Use alignment and sizing controls deliberately. After merging, use Wrap Text, horizontal alignment, and row height or column width to make the label readable. A merged cell’s width is the combined width of its columns, so changing one column may affect the overall appearance.
Remember that XLS is an older format. Merging works in XLS, but an old-format workbook may show compatibility warnings for other Excel features. If the workbook is shared with people using recent Excel versions, consider saving a separate XLSX copy while retaining the original when needed.

Troubleshooting

The merge command is unavailable or disabled. Check that you selected more than one adjacent cell and are not editing the contents of a cell. Press Enter or Esc to finish editing, then select the range again. If the worksheet is protected, the protection may prevent formatting changes; ask the workbook owner to review the protection settings or provide an editable copy.
Excel warns that only the upper-left value will be kept. Stop and inspect the selected range. If you need the other entries, cancel the merge and copy or combine them before trying again. If you proceed, those other cell contents are removed from the merged range.
The heading is not centered. Use the dropdown and choose Merge & Center, rather than Merge Cells. If it is still not visually centered, check the horizontal alignment setting and whether the text wraps onto more than one line.
The text is cut off or the merged cell looks too small. Turn on Home > Alignment > Wrap Text, then adjust the row height or the widths of the columns that make up the merged area. If the worksheet has an unusually fixed layout, you may prefer a shorter heading or a larger area.
You cannot sort or filter the range as expected. Merged cells within the data area are a likely cause. Unmerge those cells and restore a consistent grid with one value in each appropriate cell. Keep any merged report heading outside the range you sort or filter.
You merged the wrong range. Immediately use Ctrl+Z on Windows or Command+Z on Mac to undo the change, then select the correct cells. If you have already performed other actions, select the merged area and choose Home > Alignment > Merge & Center dropdown > Unmerge Cells. Unmerging restores separate cells, but it does not bring back values that were discarded during the original merge.

Frequently Asked Questions

Does merging cells in an XLS file delete data?
It can. Excel keeps the content in the top-left cell of the selected range and removes content in the other cells. Check the selection and preserve any entries you need before merging.

Can I merge cells without centering the text?
Yes. Open the dropdown beside Merge & Center and choose Merge Cells. To center a heading over columns while keeping the cells separate, use Center Across Selection in Format Cells instead.

What is the difference between Merge Cells and Merge Across?
Merge Cells combines the entire selected rectangular range into one cell. Merge Across makes separate merged areas for each row in the selection, which is useful when each row needs its own heading or label.

How do I unmerge cells?
Select the merged area, then choose Home > Alignment > Merge & Center dropdown > Unmerge Cells. The original cell boundaries return, but content removed from non-top-left cells is not recovered by unmerging.

Can I merge cells in Excel for the web or on a Mac?
Yes. Excel for the web and Excel for Mac provide merge options on the Home tab. Ribbon placement can vary, so look in the Alignment group; the exact options may differ slightly by version.

Why should I avoid merged cells in a spreadsheet table?
Merged cells can make sorting, filtering, selecting, and editing records difficult because the range no longer has a consistent cell structure. Use them for presentation headings outside the data table, not for cells that hold individual records.

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.