How to Copy Merged Cells in Excel Without Losing Layout

How-to basics · Updated November 20, 2026

To copy a merged cell in Excel, select the entire merged area, press Ctrl+C, choose a clear destination that can accommodate the same cell layout, and press Ctrl+V. If you only need the text or number, copy the value from the merged cell’s upper-left cell instead. Preparing the destination first helps prevent merge conflicts and unwanted changes to nearby cells.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows.
  • The merged cell or range you want to copy, and a destination with enough clear space.
  • Optional: a spare worksheet or a saved copy of the workbook if the destination contains important data.

You do not need a special add-in or formula. Copying a merged cell can also copy its formatting and merge arrangement, so decide whether you want the whole layout or only its contents before you begin.

Step-by-Step

  1. Identify the full merged area. Click the cell that appears merged. Although it looks like one large cell, it consists of multiple underlying worksheet cells combined into one display area. Check the Home tab and look at Merge & Center in the Alignment group; the control may show that merging is active. You can also click the cell and check the Name Box to see the selected range. For example, a merged cell might occupy B2:D2, which is three columns wide and one row tall.
  2. Choose what you need to copy. If you want the merged appearance, its contents, and its formatting, copy the full merged area. If you only want the text or number, use the value in the upper-left cell of the merged area. Excel stores the cell’s content in that upper-left cell; the other cells in the merged range do not hold separate values. Copying just the content is often the safer choice when the destination is not supposed to be merged.
  3. Check the destination before copying. Decide where the copied cell should go and make sure that area is empty or that any existing content can be replaced. For a merged area that is three columns wide and one row tall, allow the destination at least that same footprint. Also check whether the destination overlaps a different merged range. A paste that cuts across only part of an existing merge can produce an error or change the layout unexpectedly.
  4. Select the source cell or range. Click the merged cell once to select it, then confirm that the entire merge is selected rather than just a cell inside the area. If you are copying several adjacent cells that include merged areas, select the whole intended range carefully. Avoid dragging across only part of a merge. If the range is difficult to select, click the Name Box to the left of the formula bar, type the full range address, such as B2:D2, and press Enter.
  5. Copy the selection. Press Ctrl+C on Windows. A moving dashed outline usually appears around the copied area. You can also use Home > Copy on the ribbon. Do not use Cut unless you intend to move the original; copying leaves the source cell in place.
  6. Select the destination’s upper-left cell. Click the first cell where the copied range should begin. For example, if you are placing a one-row, three-column merged area starting in F2, select F2, not F2:H2. Excel uses the selected starting cell to position the copied range. Make sure the full destination footprint is available and does not conflict with another merged area.
  7. Paste the merged cell. Press Ctrl+V, or choose Home > Paste. Excel usually carries the merge arrangement and formatting along with the copied cell. Check that the result spans the intended rows and columns, displays the expected content, and has not covered information you needed to keep. If the paste fails, do not repeatedly try different locations in the original data; see Troubleshooting below.
  8. Use Paste Special if you want a different result. After copying, select the destination and open Home > Paste to view the paste options. Choose a values option when you want the content without the source formatting. Choose a formatting option when you want appearance rather than the source value. The exact options shown can depend on the copied content and Excel version. If preserving a clean, unmerged destination is essential, copying only the upper-left cell’s content is more predictable than pasting the entire merged range.
  9. Confirm the result and save. Click the destination and inspect the formula bar to verify the value. If you copied the layout, check the merge boundaries and alignment too. If anything looks wrong, press Ctrl+Z immediately to undo the paste, then prepare a different destination or copy only the content. Save the workbook after confirming the result.

On Mac: The same general steps apply in Excel for Microsoft 365. Use Command+C to copy and Command+V to paste instead of the Windows Ctrl shortcuts. Ribbon commands such as Home > Copy and Home > Paste are also available. Excel for the web has similar copy and paste options, although browser and operating-system shortcuts can affect which key combination works; use the ribbon if a shortcut is intercepted.

Common Mistakes

  • Selecting only part of a merged area. A merged cell is a single displayed unit, but it occupies several grid cells. Selecting or pasting into only part of it can cause an error. Check the full range address before copying and allow the same footprint at the destination.
  • Expecting all cells in the merge to contain separate values. Excel keeps the content in the upper-left cell of the merged range. If you need a value from the merged cell, copy that content; selecting another position inside the merge will not reveal a separate entry.
  • Pasting over existing information without checking. A paste may replace content or formatting in the destination area. Confirm that the space is clear, or paste into a temporary area first so you can inspect the result before moving it into the final sheet.
  • Copying the whole merge when you only need its text. A full copy can bring over the merge and formatting. That may be unwanted in a table, form, or data range that needs individual cells. Copy only the content when the destination should remain unmerged.
  • Merging destination cells before checking the source shape. A destination merge with a different number of rows or columns may not match the copied area. Compare the source and destination dimensions before pasting, rather than trying to force a mismatched layout.

Tips

  • Use the Name Box for precise selections. Typing a range such as B2:D2 into the Name Box can be easier than dragging over a small merged area, especially when the worksheet is zoomed out or crowded.
  • Use Format Painter for appearance only. If you need to reproduce formatting, select the source and choose Home > Format Painter, then apply the formatting to the target. It does not copy the source value. Because merging changes the worksheet structure, confirm whether the target needs the same merge arrangement too.
  • Keep a plain-cell alternative in mind. Merged cells are useful for headings, but they can make sorting, filtering, selecting, and filling data more difficult. For a heading across several columns, consider leaving the cells unmerged and using Home > Alignment settings, such as Center Across Selection where available in the Format Cells alignment options, if you need centered text without combining cells.
  • Test an unfamiliar paste on a spare area. If the destination contains formulas, borders, or important formatting, copy the merged cell to a blank worksheet area first. Check what Excel carries over, then undo or delete the test copy before changing the real layout.
  • Use Undo promptly if the layout changes. Ctrl+Z on Windows, or Command+Z on Mac, reverses the last paste in most cases. Undo before making other edits so you can return the worksheet to its previous state cleanly.

Troubleshooting

Excel says you cannot change part of a merged cell. The selected destination probably intersects an existing merged area without including all of it. Press Escape to stop the current operation. Choose a destination outside that merge, or unmerge the destination first using Home > Merge & Center > Unmerge Cells. Unmerging does not restore separate values that may have been discarded when the cells were originally merged, so check the destination before changing it.

The paste does not work or Excel reports that the merged cells must be the same size. Compare the source and destination areas. Ensure the destination does not overlap another merge and that there is enough clear space for the copied shape. If you do not need the merge, copy the content from the source’s upper-left cell and paste it into a regular destination cell instead.

The destination looks merged when you wanted ordinary cells. Undo the paste. Then copy only the source content, rather than copying the complete merged range. One straightforward approach is to select the upper-left source cell, copy it, and paste into the destination. If you also want a particular style, apply formatting separately with Format Painter or the Paste Special formatting option.

The copied cell appears blank. Click the source merge and inspect the formula bar. The content may be an empty string, hidden by a number format, or stored in the upper-left cell while you were trying to copy a different position. If the formula bar shows a value, check the destination’s font color, number format, and column width. If it is genuinely empty, there is no value to copy.

Excel pastes the value but not the appearance you expected. Use the Paste options that appear after pasting, or choose the appropriate option from Home > Paste. A values-only paste intentionally leaves out much of the source formatting; a formatting-only paste does not bring over the value. If the exact merge layout matters, copy the entire merged area and use a matching, clear destination.

Frequently Asked Questions

Can I copy a merged cell into a normal, unmerged cell?

Yes, but copying the whole merged area can also bring its merge arrangement, and the result depends on the destination layout. If you want the destination to remain a normal cell, copy only the content from the source’s upper-left cell and paste that into the target.

Does copying a merged cell copy its formatting?

A standard copy and paste generally carries the cell’s formatting along with its contents and merge layout. Use a values paste to avoid bringing over the source appearance, or a formatting paste when you want appearance without the value. Check the paste options available in your Excel version.

How do I copy a merged cell without changing the original?

Use Copy, not Cut. Select the merged area, press Ctrl+C on Windows or Command+C on Mac, then paste at the destination. The source remains in place. If you want only the value copied, copy the upper-left source cell instead.

Why does Excel say the merged cells must be the same size?

The source and destination may have different merge shapes, or the destination may overlap part of another merged area. Select a clear destination with a compatible footprint, or copy only the value into an unmerged cell.

Can I copy several merged cells at once?

Yes, if you select the complete source range and the merges are arranged in a way Excel can paste as a whole. Avoid cutting through a merge at the edge of the selection. If the range produces an error, copy each complete merged area separately or use regular cells for the destination layout.

What if I only want to duplicate the text in the merged cell?

Copy the content from the merged area’s upper-left cell and paste it into the target cell. This avoids copying the merge structure and is usually the best approach when filling a list or table with ordinary, unmerged 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.