How to Merge Cells in Excel for the Web: Step-by-Step

How-to basics · Updated November 18, 2026

To merge cells in Excel for the web, select the adjacent cells you want to combine, open the Home tab, select the arrow beside Merge & Center, and choose the merge option you need. Merging makes a selected range act like one larger cell, which is useful for headings and labels. Before you do it, check the range for content: Excel keeps the value in the upper-left cell and may remove values from the other cells when they are merged.

What You’ll Need

  • A Microsoft account and access to the workbook in Excel for the web.
  • Permission to edit the worksheet. If the workbook is view-only or the sheet is protected, you may need the owner to grant access or unprotect the sheet.
  • A clear idea of which cells to combine. The cells must form one adjacent rectangular range; you cannot merge separated cells into a single cell.
  • A copy or saved version of important data if the selected cells contain values you may need later. Excel for the web saves workbook changes automatically, so make a copy before experimenting on important content.

Step-by-Step

  1. Open the workbook in Excel for the web. Go to the workbook in your browser and make sure it opens in editing mode, not read-only mode. If someone shared a link with you, check that the link allows editing. Select the worksheet tab that contains the cells you want to combine. If several people are editing the file, let them know before making a layout change that could affect their work.
  2. Inspect the cells before selecting them. Look through the range and note whether any cell besides the upper-left cell contains text, numbers, or a formula result. A merged range can display only one cell value. The value in the range’s upper-left cell is the one Excel keeps; other values can be discarded. Copy anything you need to retain to an unused area, another worksheet, or a separate workbook before merging.
  3. Select a contiguous rectangular range. Click the first cell, then drag across and down to include the full area you want merged. You can also click the range’s first cell, hold the mouse button, and drag to its last cell. For example, selecting B2 through D2 creates a three-column heading area, while selecting A1 through A3 makes a vertical range. Check the highlighted outline before continuing: a selection that includes extra rows or columns will merge those too.
  4. Open the merge controls. With the range still selected, choose the Home tab on the ribbon. Find Merge & Center in the Alignment area. Select the small arrow beside the command to see the available choices. If the ribbon is narrow, the command may appear in a compact layout or under a ribbon menu; expand the ribbon or widen the browser window if you cannot see it.
  5. Choose the merge behavior that fits the layout. Select Merge & Center to combine the range and center the remaining value. Select Merge Cells to combine the cells without applying centering. Select Merge Across when you want separate merged ranges for each row of a selection that covers more than one row. Choose Unmerge Cells only if the selected range is already merged and you want to split it back into individual cells.
  6. Review any warning and confirm the result. If Excel warns that merging keeps only the upper-left value, stop if you need values elsewhere in the selection. Cancel, copy those values somewhere safe, and then try again. If you are ready to proceed, confirm the action if prompted. Excel combines the cells and retains the upper-left cell’s content; with Merge & Center, it also centers that content across the merged area.
  7. Adjust the appearance if needed. A long heading may still be difficult to read even after it is centered. Use the Home tab’s font, alignment, and text-wrapping controls to refine its display. You can resize the columns or rows by dragging their boundaries. If the merged range is too wide or too tall, undo the merge and select a better-sized range rather than merging additional cells blindly.
  8. Check the worksheet after merging. Click outside the merged range, then select it again to confirm the outline covers the intended cells. Verify that the displayed content is correct and that nearby formulas, labels, and formatting still make sense. Excel for the web saves changes to the workbook automatically, but wait for any saving indicator to finish before closing the browser tab or moving to another task.

Common Mistakes

Merging cells that contain several needed values: This is the most important risk. For example, if B2 contains a month name and C2 contains a year, merging B2:C2 does not join the text into a single phrase. Excel preserves the upper-left cell’s value and removes the other cell’s value from the merged result. Combine or copy the information first if both parts matter.

Using Merge & Center when you only want a wider cell: This option changes alignment as well as the cell structure. If centering is not wanted, choose Merge Cells instead, or merge and then set the alignment you prefer. A merged heading can be centered across columns without centering the rest of the worksheet.

Selecting too large or an irregular range: The merge applies to the highlighted selection, not just the cell where you clicked first. Review the selection border before choosing a command. Excel can merge only a rectangular block, so selecting multiple separate areas does not create one merged cell for all of them.

Merging cells in a table or data list: Merged cells are generally unsuitable for structured data, and Excel does not allow ordinary cell merging inside an Excel table. A table needs consistent rows and columns for sorting, filtering, and other table features. If the command is unavailable, check whether the range is part of a table.

Assuming unmerge restores deleted values: Unmerging separates the cells again, but it does not bring back values that were removed when the cells were merged. Recover those values from a copy, version history, or undo if available; do not assume Unmerge Cells reverses data loss.

Tips

Use merged cells mainly for presentation, such as a report title above a small summary. Keep the underlying records in a normal grid with one value per cell. This makes the data easier to sort, filter, select, and reuse in formulas. If you are preparing a list that will be analyzed later, a label in its own column is usually more practical than merging cells over several rows.

For a heading that spans several columns, select only the cells in the heading’s row. This gives you a clean horizontal title without changing the row structure beneath it. If several rows need individual headings, select the full block and use Merge Across to create one merged range per row. Check the result carefully because Merge Across does not create one large merged block covering every selected row.

Plan the layout before merging. Decide where the heading starts and ends, and keep the merged area away from cells that need to be independently edited. You can apply borders, fill color, font size, and alignment after merging. If you expect the sheet to change often, consider using alignment options such as Center Across Selection in desktop Excel instead of merging; this can preserve individual cells, but that specific alignment setting is not available in Excel for the web.

In a shared workbook, remember that a merge changes the worksheet for everyone with access, not just your browser view. Make structural edits when collaborators are unlikely to be editing the same area. If the worksheet has important formulas nearby, review them afterward and test any sorting or filtering workflow you rely on. Merged cells can make some selection and data-management tasks less convenient.

Troubleshooting

The merge command is missing or disabled: Confirm that you are on the Home tab and have selected a cell range. If the workbook opened in viewing mode, switch to editing if you have permission. If the cells are inside an Excel table, convert the table to a normal range only if that change is appropriate for the workbook; table design and features will be affected. A protected sheet may also block formatting changes, so ask the workbook owner to allow editing or remove protection.

Excel will not merge the selection: Check that the selection is a single rectangular block of adjacent cells. If you selected several separate ranges, clear the selection and merge each block separately. Also make sure that the range does not cross an unsupported table area. If the workbook is being edited by others, wait briefly and try again after confirming that the selection is still active.

The wrong text appears after merging: Excel keeps the upper-left cell’s content, not necessarily the value you intended to display. If the merge just happened, use Undo immediately if it is available, then move the desired value into the upper-left cell and merge again. If the workbook has already been saved or other edits have followed, check version history or a separate copy before changing anything further. Unmerging alone will not restore discarded values.

The text looks off-center or is cut off: First confirm whether you chose Merge & Center or Merge Cells. The latter does not center the text automatically. Select the merged cell and use the alignment controls on the Home tab. If the text is clipped, widen the columns, increase the row height, or turn on text wrapping where suitable. Merged ranges can behave differently from ordinary cells when rows and columns are resized, so inspect the full heading after each adjustment.

The worksheet is hard to sort or filter afterward: Merged cells can interfere with operations that expect each row to have the same structure. If the range is part of a data list, unmerge it and restore a consistent layout. Keep merged cells outside the list, such as in a title area above the table. If you already lost information, check Undo, workbook version history, or an earlier copy rather than typing guessed values into the sheet.

Frequently Asked Questions

Can I merge cells in Excel for the web?
Yes. Select the cells, open Home, and use the arrow beside Merge & Center to choose a merge option. The workbook must allow you to edit the worksheet.

Will merging cells combine their text?
No. It does not concatenate the contents. Excel retains the upper-left cell’s value and may discard values in the other selected cells. Combine the text yourself or preserve the other values before merging.

How do I merge cells without centering the text?
Choose Merge Cells from the merge menu rather than Merge & Center. You can also adjust alignment afterward from the Home tab.

Can I undo a merge?
Use Undo promptly if the merge was your latest action. Otherwise, select the merged cell and choose Unmerge Cells from the merge menu. Unmerging restores separate cells but does not restore values removed during the merge.

Why can’t I merge cells in my worksheet?
The range may be inside an Excel table, the sheet may be protected, or you may have view-only access. Check the table, protection, and sharing settings, or ask the workbook owner to change them.

Does Merge Across make one large merged block?
No. It merges cells across each row separately. For example, selecting A1:C3 and choosing Merge Across creates one merged range in each of the three rows, rather than one range covering all nine cells.

Related

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.