To merge cells in Excel for the web, select a rectangular range, open the Home tab, and choose the option you want from the Merge & Center menu. Check the selected cells first: merging keeps the value in the upper-left cell and discards values in the other cells. Merging is useful for a heading across columns, but it changes the worksheet’s layout and can make sorting or filtering harder.
What You’ll Need
- A workbook open in Excel for the web in a supported browser, with permission to edit it.
- A rectangular block of adjacent cells to merge. Decide in advance which cell’s content should remain; Excel keeps the upper-left cell’s value.
- If the other cells contain information you need, copy or move it elsewhere before merging. Unmerging later does not bring discarded values back.
Step-by-Step
- Open the workbook and find the range. Open the file in Excel for the web and go to the worksheet containing the cells. If the workbook opens in view-only mode, use the available editing option or ask the owner for edit access. Choose the sheet and identify the exact cells you want to combine. For example, to make one heading span columns A through D in row 1, the range is A1:D1.
- Check the cells before selecting them. Look for values, formulas, or text in every cell in the proposed range. Excel retains only the contents of the upper-left cell when it merges cells. If another cell has text that matters, copy it to a note, another cell, or a separate sheet first. Also check whether a formula refers to cells in the range; after merging, references and calculations may no longer behave as intended.
- Select one rectangular range. Click the first cell and drag to the last cell, or click the first cell and Shift-click the last one. You can also click the Name Box beside the formula bar, type a range such as A1:D1, and press Enter. The selection must be a single rectangle of neighboring cells, not several separated areas. Confirm that the highlight covers only the cells you intend to merge.
- Open the merge controls. Select the Home tab on the ribbon. Find Merge & Center in the Alignment area. Depending on the ribbon layout, the control may appear as a button with a dropdown arrow. If the ribbon is compact, widen the browser window or open the relevant ribbon group so the command is visible.
- Choose the merge behavior. Open the dropdown and select the option that matches your layout. Merge & Center joins the selected cells and centers the remaining content horizontally. Merge Cells joins them without centering the content. Merge Across merges cells across each selected row separately; for example, selecting A1:D3 and using this option makes one merged cell in each row, rather than one large merged block. If the menu offers only a single merge button, use the displayed option and then adjust alignment from the Home tab if needed.
- Confirm any warning and check the result. Excel may notify you that merging keeps only the upper-left value. If you see that message, stop if you have not yet saved or copied content you need. Otherwise, confirm the action. Check that the intended range became one cell, that the correct text remains, and that the alignment looks right. If the text is hard to read, adjust the column width, row height, or alignment controls.
- Save and verify the workbook. Excel for the web usually saves changes to a file stored in OneDrive or SharePoint automatically, but check the save status near the top of the page before closing the tab. If the workbook is shared, make sure your change did not disrupt a layout another person is editing. You can use Undo immediately if the result is wrong, but do not rely on Undo after closing or refreshing the workbook.
For a single centered heading, a typical example is selecting A1:D1, choosing Merge & Center, and typing the heading in the merged cell. If you have already entered the heading in A1, it remains there and becomes centered across the merged range. If the heading is in B1 or another cell in the range, move it to A1 first or copy it before merging so it is not lost.
Common Mistakes
- Merging before checking every cell. The other cells’ contents are discarded, even if they contain formulas. Copy needed information before you apply the command.
- Choosing Merge & Center when you only want to join cells. This option also changes horizontal alignment. Choose Merge Cells if you want to preserve the current alignment, or reset alignment after the merge.
- Selecting too much or the wrong shape. A large range can create one oversized merged cell, while a non-contiguous selection may not be accepted. Confirm the highlighted rectangle before using the menu.
- Expecting Merge Across to create one single cell. It creates separate merged cells for each row in the selected range. For a single heading across several rows and columns, use the regular merge option instead.
- Using merged cells in a data table. Merged cells can interfere with sorting, filtering, filling, selecting, and copying rows consistently. Keep a data list in a regular grid with one value per cell; merge only in presentation areas such as a title above the table.
- Assuming unmerge restores deleted values. Unmerge returns the range to separate cells, but it does not recover content removed by the original merge. Use Undo soon after the merge if you need to restore the prior contents.
Tips
- Use merging mainly for labels and headings. It is usually safer to merge a heading above a report than cells inside the report’s rows. Keeping the actual data unmerged makes later sorting, filtering, and analysis easier.
- Keep the intended value in the upper-left cell. For a range A1:D1, that is A1. Move the text there before merging, rather than expecting Excel to combine text from all four cells.
- Consider alternatives for a visual effect. If the goal is simply to make a heading look centered across columns, try centering the text in a single cell and adjusting column widths, or use cell formatting that does not combine the data cells. The exact alignment options available can vary in the web ribbon, but a non-merged layout is generally more flexible.
- Choose Merge Across for repeated row labels only when appropriate. It can help format grouped labels across a set of rows, but inspect each row afterward. Each row’s merged area retains the value from its own leftmost cell.
- Use Undo as an immediate safety net. If the result is not what you wanted, select Undo on the toolbar or press Ctrl+Z on Windows. In a browser, Ctrl+Z may also be handled by the page depending on focus, so the toolbar’s Undo control is a reliable alternative. Mac users can generally use Command+Z.
- Coordinate changes in shared workbooks. If other people are editing the same sheet, tell them before changing a shared layout. A merged cell can affect where collaborators can enter data and how their selections behave.
Troubleshooting
The merge command is unavailable or greyed out. First check that you are in editing mode and that the workbook is not protected or open with view-only permissions. Select a normal rectangular range of cells on the worksheet, rather than a chart, text box, or several separate ranges. If the selection includes incompatible areas or the workbook is in a restricted state, the command may not be available. Ask the workbook owner to check permissions or protection if you cannot enable editing.
The wrong text remains after merging. Excel keeps the upper-left cell’s content. If you have not done more work since the merge, use Undo immediately. If Undo is no longer available, unmerge the cells and restore the missing text from a backup, version history, or another copy of the workbook. Unmerging by itself will not recover discarded content.
The text looks off-center or is cut off. If you chose Merge Cells, the content may remain left-aligned. Select the merged cell and use the horizontal alignment controls on the Home tab. If text is clipped, increase the column width or row height, or turn on text wrapping if that option is available. A merged range can make automatic sizing less predictable, so adjust the dimensions manually and inspect the full text.
Sorting or filtering stops working as expected. Merged cells inside the data area are a common cause. Undo the merge if it was just applied, or unmerge the affected cells and restore the values to a standard one-cell-per-field layout. Put group headings above the data rather than merging cells within the rows that need sorting or filtering.
You cannot find the dropdown. Look on the Home tab in the Alignment group and check for a small arrow beside Merge & Center. In a narrow browser window, some ribbon commands may be collapsed. Expand the window, open the overflow or collapsed ribbon controls, or use the ribbon search if it is available in your Excel interface. Command placement can change slightly as Microsoft updates the web app.
Frequently Asked Questions
Can I merge cells in Excel for the web?
Yes. Select a rectangular range, open Home, and use the Merge & Center control or its dropdown. The exact appearance of the ribbon can vary with window size.
Will merging combine the text from all selected cells?
No. Excel keeps the contents of the upper-left cell and discards the contents of the other cells in the selection. Copy or move anything important before merging.
Can I merge cells without centering the text?
Yes, if the dropdown shows Merge Cells, choose that instead of Merge & Center. You can also change the alignment afterward using the Home tab’s alignment controls.
What is the difference between Merge Across and Merge Cells?
Merge Across creates separate merged cells row by row in the selected range. Merge Cells joins the whole selected rectangular range into one cell. In both cases, only the upper-left value within each merged area is retained.
Can I unmerge cells later?
Yes. Select the merged cell and use the merge dropdown’s unmerge option, if shown. The cells separate again, but Excel does not restore values that were discarded when they were merged.
Does merging affect sorting and filtering?
It can. Merged cells within a table or list may prevent reliable sorting, filtering, and data entry. Keep the table’s body cells unmerged and use merges for headings or other display-only areas.
Related
- Excel Payment Log: How to Track Payments and Balances
- Excel Payment Request: Create, Track, and Send One
- Excel Columns: How to Format, Resize, and Style Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Text Spacing: Adjust, Clean, and Control CellsTo change how text appears spaced in Excel, select the cells and use Home > Alignment to adjust…
- How to Hide Multiple Columns in Excel at Once: 3 WaysTo hide multiple columns in Excel at once, select their column letters, right-click the selection, and choose Hide.…
- How to Combine Cells in Excel Into One Cell EasilyTo combine the contents of Excel cells into a new cell, join them with the ampersand operator (&)…
- How to Schedule an Email in Outlook on the WebTo schedule an email in Outlook on the web, write your message, select the arrow beside Send, choose…
- 2 Criteria Conditional Formatting in Excel: Two MethodsIn Excel for Microsoft 365 on Windows, select the cells to format, choose Home > Conditional Formatting >…
- How to Find Unique Values in Google SheetsTo list distinct values without changing your source data, enter =UNIQUE(A2:A10) in an empty cell, replacing the range…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.