Yes. In Excel for Microsoft 365 on Windows, select the cells spanning the rows, then choose Home > Merge & Center ▼ > Merge Across. Excel creates a separate merged cell for each row in the selection; it does not combine the whole selection into one large cell.
What Merge Across means in Excel
Merge Across joins adjacent cells horizontally, one row at a time. For example, selecting A1:C3 and choosing Merge Across produces three merged areas: A1:C1, A2:C2, and A3:C3. Each row is treated independently, so the result is useful when you want a heading or label to span several columns on every row.
This is different from selecting the same block and choosing Merge Cells, which combines the entire selection into one cell. Merge & Center also creates one merged cell, while centering its retained value. The wording can be confusing: Merge Across means across the columns within each row, not one continuous merge across multiple rows.
The command changes the worksheet layout, not just the appearance. A merged area still has one usable cell for data: its upper-left cell. In the A1:C3 example, those data-bearing cells are A1, A2, and A3. The other cells in each merged area no longer act as separate cells until you unmerge the area.
How to merge cells across rows
On Windows, use the following steps in Excel for Microsoft 365:
- Select the full rectangular range you want to format, such as A1:C3.
- Open the Home tab.
- In the Alignment group, open the arrow beside Merge & Center.
- Choose Merge Across.
Excel applies the merge to each row in the selected range. If you select A1:C3, it merges A1:C1, A2:C2, and A3:C3. If you select a single row such as A1:C1, the effect is just one horizontal merge. Selecting A1:A3 has no multiple columns to combine, so there is no useful horizontal merge to make.
In Excel for Mac, select the range and use the Home tab’s Merge & Center drop-down, then choose Merge Across. The ribbon’s exact spacing or layout can vary with the window size, but the command is in the same general Home-tab alignment area. Excel for the web may present a more compact ribbon; look for the merge options on Home. If the option is unavailable, check whether the selection is inside a formatted Excel table.
Check the contents before merging
Before applying Merge Across, inspect every row in the selected range. When a row contains values in more than one selected cell, Excel keeps the value in the leftmost cell and removes the contents of the other cells in that row. It can display a warning about data loss. This behavior applies separately to every row.
For instance, suppose A1 contains North and B1 contains Region, while A2 contains South and B2 is blank. Merging A1:B2 across rows keeps North in the first merged area and South in the second. The word Region is discarded. The same risk applies to formulas, not just typed text. A formula in a cell that is not the leftmost cell of its row is also removed by the merge.
To reduce risk, make a copy of the worksheet or workbook, or move the data you need to keep before merging. If you have already merged and immediately notice a mistake, use Undo (Ctrl+Z on Windows; Command+Z on Mac). Unmerging later restores separate cells, but it does not bring back values that were discarded. It is not a substitute for Undo or a backup.
Choose the right merge option
The best choice depends on whether you need a real merged cell or only a visual effect. Use Merge Across when each row should have its own wider cell. Use Merge Cells when the whole selected block should become one cell, and use Merge & Center when that single cell should also center its contents. These commands are not interchangeable if the selection covers multiple rows.
- Merge Across: creates a separate horizontal merge in every selected row.
- Merge Cells: combines the full selection into one cell without necessarily centering the value.
- Merge & Center: combines the full selection into one cell and centers its value.
- Unmerge Cells: removes the merge formatting and returns the area to separate cells.
For a report with a row label in A and a long heading intended to span B through D on each of several rows, Merge Across may fit. For a single title above a table, a one-row Merge & Center selection may be appropriate. Avoid merging a multirow block simply because it looks like a larger heading: the result has only one data-bearing cell, which can complicate later work.
Alternatives that keep the cells separate
If your goal is alignment rather than changing the worksheet structure, consider Center Across Selection. It centers text across selected cells without merging them, leaving the underlying cells available. Select the cells in a row, press Ctrl+1 on Windows to open Format Cells, choose the Alignment tab, and set Horizontal to Center Across Selection. On Mac, Command+1 opens Format Cells; the dialog’s layout may differ slightly.
Center Across Selection works best when the neighboring cells are empty, because their contents remain in their own cells and can affect what appears across the selected area. Unlike Merge Across, it does not remove data from the other cells. For a heading repeated across multiple rows, apply the alignment to the horizontal range in each row, or select the full multirow range and check the visual result.
Other alternatives can be simpler still. Widen a column, use Wrap Text so long content occupies multiple lines, or adjust alignment and indentation. If a report needs a title centered over several columns, center the title visually without merging, or place it in a dedicated title row. Keeping a normal grid is especially useful when the sheet will be sorted, filtered, or used as a data source.
Effects on tables, sorting, and formulas
Merged cells are primarily a presentation feature and can make data operations less predictable. Excel does not allow merging cells within a formatted Excel table. If the command is unavailable, check whether the selection is part of a table. Converting a table to a range can make merging possible, but doing so removes table features such as structured references and automatic table expansion. Do not convert just to force a merge unless those features are no longer needed.
Merged areas can also interfere with sorting and filtering. A sort expects a consistent row-and-column grid, while a merged range spans multiple cells. Depending on the selection and layout, Excel may block the operation or make it awkward to sort the intended records. Filters rely on column headings and distinct records; merging cells across data columns can obscure that structure. Keep headings and data in ordinary cells if the worksheet is meant to be analyzed.
Formulas can refer to the upper-left cell of a merged area, but the other positions in that area are not separate populated cells. This matters when copying formulas, filling ranges, or using references to cells that appear to be covered by a merge. A workbook may look orderly while its underlying grid is harder to maintain. For data entry sheets, use merges sparingly and keep one record per row with one field per column.
Unmerge cells and handle common problems
To reverse the layout, select a merged area and choose Home > Merge & Center ▼ > Unmerge Cells. You can select multiple merged areas and unmerge them together, provided the selection is suitable. The cells become separate again, but Excel places the surviving value in the upper-left cell of each previously merged area; it does not reconstruct the former contents of the other cells.
If Merge Across is greyed out, check whether the worksheet is protected, whether the selection intersects a table, and whether the workbook or sheet has restrictions that prevent formatting changes. If a selection contains more than one row, also confirm that Merge Across—not Merge Cells or Merge & Center—is the option you chose. After applying it, inspect the row boundaries to make sure the separate merges match the layout you intended.
If the result appears off-center, note that Merge Across does not mean Merge & Center: the command does not automatically center the content in each merged area. Set horizontal alignment separately from the Home tab or Format Cells. If you are only trying to make text visible, try Wrap Text or adjust column width before merging. This often avoids side effects while solving the original display problem.
Frequently Asked Questions
Can I merge cells across multiple rows in Excel?
Yes. Select a range covering multiple rows and columns, then choose Merge Across. Excel makes one horizontal merged area per row, rather than one merged block covering the whole selection.
Does Merge Across keep all the data?
No. In each row, Excel keeps the contents of the leftmost cell in the selected range and removes contents from the other cells in that row. Check the selection first and make a copy if the other values matter.
What is the difference between Merge Across and Merge Cells?
Merge Across creates separate horizontal merges for each row in the selection. Merge Cells combines the entire selected range into one cell. Merge & Center also combines the whole range but centers the surviving value.
Can I sort a range that contains merged cells?
Merged cells can prevent or complicate sorting because they do not form a regular grid. For sortable records, unmerge the cells and keep each field in its own column. Use formatting or Center Across Selection for presentation instead.
How do I merge cells without losing data?
Move or combine values into the leftmost cell before merging, or keep the cells separate and use Center Across Selection or another formatting option. Excel’s merge command does not preserve multiple cell values inside one merged area.
Related
- Excel: Hide Column Headers Without Hiding Data
- Excel: Hide a Column When a Cell Contains Text
- Excel Heat Mapping: How to Create Useful Color Scales
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Double Space in Word Desktop and Format TextTo double-space text in Word desktop, select the text, then choose Home > Line and Paragraph Spacing >…
- How to Apply Data Validation to an Entire Excel ColumnIn Excel for Microsoft 365 on Windows, select the column by clicking its letter, then choose Data >…
- Add Conditional Formatting in Excel: Rules and TipsTo add conditional formatting in Excel for Microsoft 365 on Windows, select the cells you want to format,…
- Google Sheets: How to Add Up a Column of NumbersIf your numbers are in B2:B10, enter =SUM(B2:B10) in an empty cell to add them; Google Sheets displays…
- Remove a Data Model from Excel: Steps and EffectsYes. In Excel for Microsoft 365 on Windows, remove tables from the Data Model in Power Pivot: choose…
- Conditional Formatting to Change Cell Color in ExcelIn Excel for Microsoft 365 on Windows, select the cells, then choose Home > Conditional Formatting and select…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.