To merge cells in Excel for Mac, select the range, go to Home > Merge & Center, open its dropdown, and choose a merge option. Excel keeps the content in the range’s upper-left cell and discards content in the other cells, so check the selection before merging.
How to merge cells in Excel for Mac
In Microsoft Excel for Mac, the merge controls are on the Home tab. The exact button can look slightly different depending on the ribbon layout, but it is labeled Merge & Center. You can merge a range into one cell, merge each row separately, or merge and center the content.
- Select the adjacent cells you want to combine, such as A1:C1. The range should be rectangular.
- Choose the Home tab, then click the dropdown arrow beside Merge & Center.
- Choose Merge Cells if you want one larger cell without changing the alignment, Merge & Center to merge and center the remaining content, or Merge Across to merge cells row by row.
- If Excel warns that the selection contains multiple values, review the warning before confirming. Only the upper-left value will remain.
To undo a merge later, select the merged cell, open the same dropdown, and choose Unmerge Cells. Unmerging restores the separate cell boundaries, but it does not restore data that was removed during the merge. If the button is unavailable, check that the selection is suitable and that you are not trying to merge cells inside an Excel table.
What the three merge options do
The options are not interchangeable. Choosing the one that matches the layout you need can prevent surprises in both the appearance and the structure of your worksheet.
- Merge & Center: Combines the selected cells into one and centers the upper-left cell’s content. This is a common choice for a heading spanning several columns.
- Merge Cells: Combines the selection but does not apply centering. The resulting cell uses the alignment settings associated with its content or formatting.
- Merge Across: Merges the cells across each row of the selected range, rather than making the entire selection one cell. For example, selecting A1:C3 and choosing Merge Across creates three merged cells: A1:C1, A2:C2, and A3:C3.
If you select a single row of cells, Merge Across and a regular merge may appear to give a similar result. Their difference becomes important when your selection covers several rows. For a heading across three columns and one row, Merge & Center is usually the most obvious choice. For a label that should stay left-aligned, Merge Cells may be more appropriate.
What happens to data when cells are merged
A merge changes the worksheet layout; it does not combine the values from the selected cells into a single text string. Excel retains the value in the upper-left cell of the selected range. Other values in the range are removed when the merge is completed. For example, if A1 contains Region and B1 contains West, merging A1:B1 leaves Region and removes West.
This rule applies even if the cells contain formulas. If several cells contain data you need, do not rely on merging to preserve it. Before merging, copy the values elsewhere, or combine the information in a separate cell first. For example, you could put Region West into a new cell as ordinary text, then merge an empty range for the visual heading. If the information must remain separately usable for calculations, sorting, or filtering, do not merge those data cells.
Excel may display a warning when the selected range has more than one non-empty cell. Treat that warning as a chance to stop and inspect the range, not as a prompt that promises to combine the values. Once the merge is complete, choosing Unmerge Cells will not bring back the discarded entries. Keeping an untouched copy of important source data is a useful precaution when restructuring a workbook.
When merging makes sense—and when it does not
Merging is most useful for presentation: a report title above several columns, a section label over a group of cells, or a form heading across a fixed-width area. These are cases where the larger visual block is more important than treating every cell underneath it as an independent data field.
It is usually a poor choice for the body of a list or dataset. A table with one row per transaction, person, or product works best when every record has the same columns and each field occupies its own cell. Merged cells can interfere with sorting, filtering, selecting ranges, pasting, and other operations that expect a regular grid. Excel does not allow cells to be merged inside a formatted Excel table, either. If the merge command is disabled while working in a table, that restriction may be the reason.
A practical rule is to keep raw data unmerged and apply merges only to a separate presentation area, such as a report sheet. For example, leave a sales list with headers in A1:D100 as ordinary cells, then create a report title above a summary elsewhere. This separates the structure needed for analysis from the layout used for reading or printing.
Centering across columns without merging
If you want a heading to look centered across several columns but want to keep those cells separate, use Center Across Selection instead. Unlike a merge, this alignment option leaves the cells as individual cells, which is generally friendlier to editing and data operations. It is a useful alternative for a title such as Quarterly Summary above columns A through D.
To set it in Excel for Mac, select the cells, open Format > Cells from the macOS menu bar, choose the Alignment tab, and select Center Across Selection from the Horizontal alignment options. Click OK to apply it. The heading should be in the leftmost selected cell; the other cells can remain empty. If you cannot find the option in your Excel version or layout, use the Format Cells dialog’s alignment controls and check the available horizontal choices.
Center Across Selection does not turn several values into one value, and it does not make the cells a single large target for editing. It only changes the horizontal display of the content. That distinction matters when a worksheet will later be sorted, filtered, copied, or expanded. For simple visual headings, it can provide much of the look people want from Merge & Center while preserving the grid.
Common problems and how to fix them
- The merge button is unavailable: Confirm that you selected more than one cell, and check whether the range is inside an Excel table. Table cells cannot be merged; convert the table to a normal range only if you no longer need its table features.
- Some text disappeared: Excel retained only the upper-left value. Unmerging will not recover the other entries, so restore them from a backup or the original source if available.
- The heading appears in the wrong place: Merge Cells does not necessarily center content. Choose Merge & Center, or adjust the alignment after merging.
- Sorting or filtering behaves unexpectedly: Look for merged cells in the data area. Unmerge them and keep each record in a consistent row-and-column structure.
- The merged cell is hard to select or edit: Click within the visible merged area, or use the Name Box to select the range. For future layout work, consider Center Across Selection instead.
Also remember that a merged cell can make a worksheet harder to navigate with a keyboard or assistive technology. A screen reader or a user moving through cells may encounter a larger area that does not behave like the surrounding grid. For shared workbooks, especially data-entry sheets, simpler cell structures are usually easier for more people to use.
Frequently Asked Questions
Can I merge cells in Excel for Mac?
Yes. Select the range and use Home > Merge & Center. The dropdown offers merge choices, including Merge Cells, Merge Across, and Merge & Center. The command may be unavailable for cells inside a formatted table.
Does merging cells combine their text?
No. Excel keeps the value in the upper-left cell and removes values in the other selected cells. If you need every value, combine or copy the information before merging, or keep the cells separate.
Can I unmerge cells and get the original contents back?
You can select the merged cell and choose Unmerge Cells, which restores the cell boundaries. It does not restore values that were discarded during the merge, so use a backup or source data to recover them.
What is the difference between Merge Cells and Merge & Center?
Both merge the selected cells and retain the upper-left value. Merge & Center also centers that value. Merge Cells merges without applying that centering command.
How do I center a heading without merging cells?
Select the range and use Format > Cells > Alignment, then choose Center Across Selection under Horizontal. This centers the heading across the selected cells while keeping them separate.
Related
- AI and Power Query: What It Can and Cannot Do in Excel
- Power Query Split Cell Into Rows: Steps and Examples
- Power Query Editor: How to Split Text into Multiple Columns
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Where to Add Speaker Notes in PowerPoint and Use ThemIn PowerPoint, add speaker notes in the Notes pane beneath the slide: select the slide, click Notes on…
- Google Sheets Conditional Formatting With IFYes. In Google Sheets, use Format > Conditional formatting, choose Custom formula is, and enter a formula that…
- Excel Keyboard Shortcut to Insert a Row or LineIn Excel for Microsoft 365 on Windows, select a row and press Ctrl+Shift+= to insert a worksheet row…
- Fit Columns to Text in Excel: Quick Methods and FixesTo fit a column to its text in Excel for Microsoft 365 on Windows, select the column and…
- How to Build a Schedule in Excel: A Practical GuideTo build a schedule in Excel, choose a time period, put dates or time slots in row and…
- Office Inventory Spreadsheet Template: Set It Up in ExcelAn office inventory spreadsheet template is a structured list of workplace equipment and supplies, with fields for identifying…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.