See all How-To Articles

How to Copy & Paste Merged Cells in Excel & Google Sheets

This tutorial demonstrates how to copy and paste merged cells in Excel and Google Sheets.

 

copypastemerge intro

 

Copy-Paste to Merged Cells

  1. Click on the cell which contains the data you wish to copy and then, in the Ribbon, go to Home > Clipboard > Copy (or press CTRL + C).

 

copypastemerge copy

 

  1. Navigate to the destination cell and then, in the Ribbon, go to Home > Clipboard > Paste or press CTRL + V.

 

copypastemerge paste

 

This simply takes the merged cells and copy-pastes them to a new set of merged cells.

Copy-Paste to Individual Cells

  1. Click on the cell which contains the data you wish to copy and then, in the Ribbon, go to Home > Clipboard > Copy (or press CTRL + C).

 

copypastemerge copy

 

  1. Navigate to the destination cell and then, in the Ribbon, go to Home > Clipboard > Paste > Formulas & Number Formatting.

 

copypastemerge paste formulas

 

OR
In the Ribbon, go to Home > Clipboard > Paste or press CTRL + V. Then click the box in the bottom-right corner and choose Formulas & Number Formatting.

 

copypastemerge paste formulas numbers

 

The data from the merged cells is placed in the individual cell selected as the destination cell.

 

copypastemerge paste only text

 

Copy-Paste Merged Cells in Google Sheets

  1. Copying and pasting merged cells in Google Sheets is much the same as it is in Excel.
  2. Select the merged cells and in the Menu, go to Edit > Copy or press CTRL + C.

 

copypastemerge gs copy

 

  1. Then, move to the destination cell and in the Menu, go to Edit > Paste Special > Values only or press CTRL + SHIFT + V.

 

copypastemerge gs paste values

 

The data from the merged cells is pasted into an individual cell.

 

copypastemerge gs pasted

See all How-To Articles