Document Editing Problems

How to Copy One Cell to Multiple Cells in Excel

Natalie Taylor Sep 27, 2026 870 views

Question details

The user needs to copy a single cell's data and paste it into multiple empty cells within a worksheet, but is encountering errors preventing the paste operation.

How to Copy One Excel Cell to Multiple Destination Cells

Product: Excel
Device & OS: not provided
Scenario: Trying to copy a single cell and paste it into a selected range of multiple empty destination cells, such as down a single column.
Observed behavior: Excel either reports that the destination range has a different size or pastes the copied value into only one cell instead of filling the entire selected destination range.

Before you start

Ensure that your source cell and destination cells are located on the same active worksheet, and check that you are not attempting to paste into a filtered range containing hidden rows.

Solution 1Recommended

Unmerge Source and Destination Cells

Merged cells are the most common cause of paste errors when trying to fill multiple cells. Unmerging the ranges allows Excel to paste the data correctly.

When you copy a single cell and try to paste it into multiple cells, Excel requires the destination cells to be standard, contiguous single cells. If either the copied cell or any part of the destination range contains merged cells, Excel will trigger a size mismatch error or only paste into the first cell.

Select the affected ranges

Highlight both the source cell you want to copy and the entire destination range where you want to paste the data.

Unmerge the cells

Navigate to the Home tab on the top ribbon. Locate the Merge & Center button, click the drop-down arrow next to it, and select Unmerge Cells.

Copy the source cell

Click on your single source cell again and press Ctrl + C on your keyboard to copy it to the clipboard.

Paste into the destination

Highlight the newly unmerged, contiguous destination cells and press Ctrl + V. The value will now successfully populate into every selected cell.

Tip for finding hidden merged cells: Merged cells can sometimes be difficult to spot. Selecting the entire column or row and clicking Unmerge Cells is a quick way to clear out any hidden formatting that may be blocking your paste.

Solution 2

Use Fill Shortcuts for Contiguous Cells

If you are copying data to adjacent cells in the same row or column, using keyboard fill shortcuts bypasses the clipboard and avoids standard pasting errors.

Efficient Spreadsheet Management

Easily Manage Cell Formatting with WPS Office

WPS Spreadsheet provides a highly intuitive and stable environment for handling complex data ranges. You can quickly duplicate values, use smart drag-and-fill handles, and easily manage merged cells without unexpected copy-paste errors.

1. Open your file in WPS: Launch WPS Office and open your spreadsheet file.
2. Select and copy: Click the single cell you wish to duplicate and press Ctrl + C.
3. Select destination: Highlight the multiple empty cells where you want the data to appear.
4. Paste across range: Press Ctrl + V, and WPS Spreadsheets will automatically fill all selected cells with the copied value.

100% compatible with Microsoft Excel (.xlsx, .xls) formatsSmart fill handle for instant multi-cell data entryBuilt-in error checking to easily spot merged cell conflictsFree, lightweight, and fast on Windows, Mac, and Linux

Frequently Asked Questions

Why does Excel say 'the destination range has a different size'?

This error occurs when the area you are trying to paste into contains merged cells, or if you copied a group of cells and the destination area you highlighted does not exactly match the dimensions of the copied group.

How can I paste one cell into multiple non-adjacent cells?

Copy the source cell using Ctrl + C. Then, hold down the Ctrl key while clicking on each individual non-adjacent cell you want to paste into. Once all desired cells are selected, press Ctrl + V.

How do I copy a formula to multiple cells without changing its references?

Before copying, you must lock the cell references in your formula by making them absolute. Double-click the source cell and add dollar signs before the column letter and row number (e.g., $A$1). Press Enter, then copy and paste the cell as usual.

Document & File Issues