To merge cells in Excel for Microsoft 365 on Windows, select a rectangular range of adjacent cells, then choose Home > Merge & Center or open its dropdown and select Merge Cells. There is no separate setting to switch on: the command is available on the Home tab. Before merging, check the range because Excel keeps the value in the upper-left cell and removes content from the other selected cells.
Merging is useful for making a heading span several columns or grouping a label across a small area. It changes the cell layout, though, and can make sorting, filtering, copying, or working with formulas less convenient. If you only want text to look centered across columns without joining cells, consider the safer alternative described in the Tips section.
What You’ll Need
- A workbook open in desktop Excel for Microsoft 365 on Windows. The ribbon steps are similar in current Excel for Mac and Excel for the web, although the layout and keyboard shortcuts can differ slightly.
- A rectangular range of adjacent cells that you want to combine. The cells must be on the same worksheet.
- A saved copy or a clear plan for any contents other than the one in the upper-left cell. Merging can remove those other values.
Step-by-Step
- Open the worksheet and identify the range. Click the sheet tab containing the cells. Decide exactly which cells should become one, such as B2 through E2 for a heading across four columns. The selected cells must touch and form a single rectangle; you cannot merge separate, nonadjacent cells in one operation. If the goal is only a title, a single row is usually easier to work with later than a large block spanning multiple rows.
- Check the contents before selecting. Excel preserves the value or formula in the range’s upper-left cell. It does not combine the contents of every cell into a longer text string. For example, if B2 contains “Quarterly Sales” and C2 contains “2026,” merging B2:C2 keeps “Quarterly Sales” and discards “2026.” Move or copy anything important to another cell first. If Excel displays a warning that only the upper-left value will be kept, read it and choose whether to continue or cancel.
- Select the cells. Click the first cell, then drag to the last cell in the intended range. You can also click the first cell, hold Shift, and click the last cell, or type a range such as B2:E2 in the Name Box to the left of the formula bar and press Enter. Check the highlighted outline before proceeding. If you accidentally select a whole row, column, or extra cells, click the correct range again.
- Open the merge options. On the ribbon, select the Home tab. Find the Alignment group and locate Merge & Center. Click the small dropdown arrow beside the button to see the available commands. If the ribbon is collapsed, expand it or select Home so the group is visible. The dropdown is important because the main button’s default action is to merge the selection and center its content.
- Choose the merge behavior you want. Select Merge & Center to create one cell and center the retained content. Choose Merge Cells to create one cell without changing its horizontal alignment. Choose Merge Across to merge the selected cells separately across each row; for example, selecting B2:D4 makes one merged area in row 2, another in row 3, and another in row 4. Use Unmerge Cells only when you want to reverse an existing merge. If the warning about removing other values appears, confirm only after checking the data.
- Review the result and adjust formatting. The merged area behaves as one cell for many formatting and selection tasks. If the text is not positioned as you want, use the alignment controls on Home to set horizontal or vertical alignment, and use Wrap Text if a heading needs more than one line. Adjust the column widths or row height if the text is clipped. Merging does not automatically make every row or column a useful size, so check the result at normal zoom and in print preview if the sheet will be printed.
- Undo or unmerge if necessary. If you just merged the wrong range, press Ctrl+Z on Windows to undo. On Mac, press Command+Z. To undo a merge later, select the merged cell, open Home > Merge & Center dropdown, and choose Unmerge Cells. Unmerging restores the individual cells, but it does not bring back values that were discarded when they were originally merged. Restore those from a backup or undo history if available.
In Excel for Mac, select the range and use the Home tab’s merge control, choosing the required option from its menu. Excel for the web also provides merge commands on the Home tab. Ribbon placement can vary with window size, but look for the merge control in the alignment area. If the command is unavailable, check the restrictions in Troubleshooting rather than looking for a global setting to enable it.
Common Mistakes
- Merging before checking every cell. The most important mistake is assuming Excel will join all the text. It retains the upper-left cell’s content, not a combined version of the range. Copy any needed values elsewhere before confirming the merge.
- Using a merge for visual alignment. Merged cells can interfere with sorting, filtering, selecting a consistent range, and filling formulas down or across. A large merged title may look tidy but can complicate later edits to the data below it.
- Choosing Merge & Center by accident. Clicking the main button applies its default centered alignment. If you want the cells merged but the text left-aligned or otherwise unchanged, use the dropdown and choose Merge Cells.
- Expecting Merge Across to make one big cell. It creates a separate merge for each row in the selected area. For a single cell spanning several rows and columns, choose Merge Cells or Merge & Center instead.
- Trying to merge cells inside an Excel table. Excel does not allow merged cells within a formatted table. Convert the table to a normal range if merging is essential, but first consider whether you need the table’s sorting, filtering, and structured features.
Tips
- Use Center Across Selection when the goal is appearance. This keeps the cells separate while centering a heading across selected columns. Select the cells, open the Format Cells dialog with Ctrl+1 on Windows (Command+1 on Mac), choose the Alignment tab, then choose Center Across Selection in the Horizontal list. Select OK. This can preserve a more usable grid than merging, though the heading remains in the leftmost cell.
- Merge only headings or labels, not the data grid. A merged heading above a table is less likely to disrupt sorting than merging cells within the rows of data. Keep each record in its own row and each field in its own column.
- Plan the range before applying formatting. Choose the final row and column span first, then merge, align, wrap, and adjust sizing. This avoids repeatedly merging and unmerging as the layout changes.
- Use the dropdown rather than relying on the main button. The menu makes it clear whether you are choosing Merge & Center, Merge Across, Merge Cells, or Unmerge Cells. It is especially useful when you need alignment to remain unchanged.
- Save before making many layout changes. Merging is reversible while it remains in your undo history, but unmerging later cannot recover discarded cell contents. A saved version provides a reliable fallback when working with a complex sheet.
Troubleshooting
- The merge button is greyed out. First press Enter or Esc to leave cell editing mode, then select the range again. Excel may disable ribbon commands while you are typing in a cell or editing its formula. Also check that the selection is on one worksheet and is one continuous rectangle. A range containing cells in an Excel table cannot be merged; move the heading outside the table or convert the table to a range if appropriate.
- The command is blocked by worksheet protection. If the sheet is protected, some formatting actions may be restricted. If you have permission, use Review > Unprotect Sheet, make the change, and protect the sheet again if needed. Excel may ask for a password. Do not try to bypass protection; ask the workbook owner for access or an approved change.
- Excel warns that only the upper-left value will be kept. Cancel if you need any of the other cells’ contents. Copy or move those contents to unused cells, or combine the information in a separate cell before merging. Confirm the merge only when you are comfortable losing the other values in the selected range.
- The text disappears or appears cut off. Check the upper-left cell first: that is the one whose content remains after merging. Then widen the columns, increase the row height, turn on Home > Wrap Text, or adjust vertical alignment. If the retained text is not the one you need, undo immediately if possible and arrange the contents before trying again.
- Sorting or filtering no longer works as expected. Merged cells can create uneven data ranges, which makes common list operations difficult. Unmerge the affected cells and place headings in separate cells, or move the merged title above and outside the range you sort or filter. For a centered appearance without merging, use Center Across Selection.
- You cannot tell which cell is selected after merging. A merged area represents one cell, located at the upper-left corner of the original selection. Click the area once and check the Name Box or formula bar to identify it. To restore the grid, select the merged area and choose Home > Merge & Center > Unmerge Cells.
Frequently Asked Questions
Do I need to enable Merge Cells in Excel first?
No. The feature is built into the Home tab. Select a valid range and choose a command from the Merge & Center dropdown. If the control is disabled, check whether you are editing a cell, working inside a table, or using a protected sheet.
Does Merge Cells combine the text from all selected cells?
No. Excel keeps the content in the upper-left cell and removes content in the other selected cells when the merge is applied. Copy or combine information elsewhere before merging if you need to retain it.
What is the difference between Merge Cells and Merge & Center?
Both create a merged cell from the selected range. Merge & Center also centers the retained content horizontally. Merge Cells merges without applying that centering action, so existing alignment is a better starting point.
Can I merge cells in an Excel table?
No. Excel tables do not support merged cells inside the table. Put the heading outside the table, or convert the table to a normal range if that suits your needs. Converting can remove table-specific sorting, filtering, and structured-reference behavior, so consider the consequences first.
Can I merge cells without losing the other values?
Not with the standard merge command: it retains only the upper-left value. Copy the other values to a different location before merging, or avoid merging and use Center Across Selection when you only want a heading to appear centered over several columns.
How do I undo a merge?
Press Ctrl+Z on Windows or Command+Z on Mac immediately after merging. Otherwise, select the merged cell and choose Home > Merge & Center > Unmerge Cells. Unmerging restores separate cells but does not restore values removed during the merge.
Related
- How to Delete an Excel Workbook Safely
- How to Delete Strikethrough in Excel in a Few Steps
- Excel Calendar With Correct Dates: A Step-by-Step Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Worksheet Tabs Not Visible? How to Restore ThemIf Excel worksheet tabs are not visible, first check File > Options > Advanced and turn on Show…
- How to Create a Mail Merge Template in Microsoft WordCreate a mail merge template by starting a mail merge in Word, building the letter or other document,…
- Excel Import Multiple CSV Files: Methods and TipsTo import multiple CSV files into Excel for Microsoft 365 on Windows, put the files in one folder,…
- Excel Find and Replace: Search for a Question MarkTo find a literal question mark in Excel, open Find or Replace and enter ~? in the Find…
- Free Meal Planner Spreadsheet: Plan Meals in ExcelYes—you can make a free meal planner spreadsheet in Excel by laying out a week of meals, adding…
- How to Create 2 x 4 Labels in Word and Print Them CorrectlyTo create 2 x 4-inch labels in Microsoft Word, open Mailings > Labels, choose Options, select the matching…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.