How to Mass Copy and Paste in Excel: Safe, Fast Steps

To mass copy and paste in Excel, select the source cells and press Ctrl+C, select a destination range of the same size, then press Ctrl+V. To repeat a block, choose a destination whose rows and columns are exact multiples of the copied block. For repeated values or formulas, use Fill Down or Fill Right instead. Before pasting, check the destination carefully: Excel replaces existing content in the cells you paste into.

These steps are for Microsoft Excel for Microsoft 365 on Windows. On a Mac, use Command+C and Command+V for copying and pasting; ribbon commands work too. The key is to decide whether you are copying a one-off range, repeating a block, filling a value, or pasting only certain parts such as values. Choosing the right method helps avoid accidental overwrites and unexpected formula changes.

What You’ll Need

An Excel workbook with the source data and enough space for the pasted results.
A clear idea of the source range and destination range. For example, note whether you are copying A2:D20 into another 19-row-by-4-column area.
Permission to edit the destination sheet. A protected worksheet may prevent pasting.
If the data matters, a saved copy of the workbook or a recent save point. A large paste can replace many cells at once.

Step-by-Step

Choose the right kind of mass paste. If you need to move a large rectangular block once, use Copy and Paste. If you need the same block repeated several times, use a destination that is an exact multiple of the source dimensions. If you are copying one value or formula down a column, use Fill Down. If you need to paste results without formulas, use Paste Values. Knowing the goal first prevents using a method that changes formulas, formatting, or data unintentionally.
Check the source and destination. Look at the first and last row and column of the source, and make sure the destination has enough room. For example, copying a five-column by 100-row table requires a destination area of at least five columns by 100 rows. If you paste into a range containing existing records, those cells can be overwritten. Consider inserting blank rows or using a new worksheet if the destination is not empty.
Select the source range. Click the first cell and drag to the last cell, or click the Name Box to the left of the formula bar, type a range such as A2:D101, and press Enter. The Name Box method is useful for large ranges because it avoids scrolling and reduces the chance of missing a row. If you intend to copy a complete table, include its headers only if you also want the headers at the destination.
Copy the selected cells. Press Ctrl+C on Windows or Command+C on Mac. You should see a moving dashed border around the copied cells. You can also choose Home > Copy on the ribbon, or right-click the selection and choose Copy. Do not press Esc before pasting, because that cancels the active copy border in many Excel workflows.
Select the destination’s upper-left cell. Click the first cell where the copied block should begin. For a normal single paste, selecting this one cell is enough; Excel places the entire source block starting there. You can use the Name Box to jump to a distant destination, such as G2. Check that the area to the right and below is clear before continuing.
Paste a block once. Press Ctrl+V on Windows or Command+V on Mac, or choose Home > Paste. Excel copies the source data and, by default, its formatting and formulas. A paste of a 4-column-by-20-row selection starting in G2 occupies G2:J21. If the source has formulas, their relative references may adjust to the new location, so review a few formula cells before using the pasted results.
Repeat a copied block across a larger area, if needed. Copy the source block, then select the full destination range, not just its first cell. For example, if the source is 2 columns by 3 rows, a destination of 6 columns by 12 rows can repeat it three times across and four times down. Press Ctrl+V. The destination dimensions need to be exact multiples of the source dimensions; if they are not, Excel may reject the paste or produce a layout you did not expect. Start with a small test if the repeated pattern is important.
Fill one value or formula through a range. To repeat a value, enter it in the first cell, select that cell plus the cells below it, then choose Home > Fill > Down. To fill across columns, select the starting cell and cells to its right, then choose Home > Fill > Right. On Windows, Ctrl+D fills down and Ctrl+R fills right. On Mac, use the Home > Fill menu if your keyboard mapping differs. Filling copies the top or left cell through the selected range; it is not the same as pasting a separate multi-cell block.
Paste values or another specific part only. If the source contains formulas but you want fixed results, copy it, select the destination, and choose Home > Paste > Paste Values. You can also use the Paste Special dialog on Windows by pressing Ctrl+Alt+V, selecting Values, and confirming. Paste Special also offers options such as formulas, formats, and column widths. On Mac, use the Paste menu or the Paste Special dialog because shortcuts can differ by keyboard and Excel version.
Verify the result and save. Check the first and last pasted rows, a few cells in the middle, and any formulas or dates. Confirm that the destination dimensions are right and that existing data remains intact where it should. If the result is wrong immediately after pasting, press Ctrl+Z on Windows or Command+Z on Mac to undo, then correct the selection and try again. Save after confirming the paste.

Common Mistakes

Selecting the wrong destination size: Selecting a destination smaller or larger than intended can make Excel refuse a paste or repeat the block unexpectedly. For a one-time paste, select only the upper-left destination cell. For a repeated block, select a range whose row and column counts are exact multiples of the source.

Overwriting existing cells: Pasting does not automatically insert space or shift existing records out of the way. It replaces content in the matching destination cells. Check whether the target area contains values, formulas, or notes you need. If it does, make room first or paste to an empty worksheet.

Copying formulas when you wanted fixed values: Standard paste copies formulas and usually adjusts relative cell references to the new position. That can be helpful when extending calculations but wrong when you want the displayed results frozen. Choose Paste Values for fixed results, and inspect formulas that include relative, absolute, or mixed references.

Including headers or blank rows by accident: A copied title row may be duplicated inside the data, or blank rows may disrupt sorting and filtering later. Select the exact data range, and decide deliberately whether headers belong in the destination. When using a table, take care not to include totals or notes below it unless needed.

Assuming a filtered list copies only visible records: Copying a filtered range can behave differently depending on how the cells were selected and the Excel version. If you must copy only visible cells, use Home > Find & Select > Go To Special > Visible cells only on Windows before copying, then verify the pasted rows. On Mac, look for Go To Special under the Home tab’s Find & Select controls; menu availability can vary by version.

Tips

Use the Name Box for precise large selections. Enter a range such as B2:F5000 instead of dragging through thousands of rows.
Copy and paste a full rectangular range in one operation when possible. It is usually faster and less error-prone than copying individual columns or sections separately.
Use Paste Values when moving a report result into a workbook where you do not want formulas linked to the original sheet. Use Paste Formulas when you want calculations but not the original cell formatting.
For a long formula column, enter or copy the formula in the first cell, select the destination cells, and use Home > Fill > Down. Check that the references update as expected before relying on the entire column.
To repeat the same entry across selected cells without copying, select the range, type the entry, then press Ctrl+Enter on Windows. On Mac, Control+Return may work depending on the keyboard setup; use the ribbon or test on a small range first. This enters the same content in each selected cell.
For very large pastes, wait for Excel to finish before clicking elsewhere. A large workbook may pause while it recalculates formulas or applies formatting. Avoid starting a second paste while the first operation is still processing.
If appearance matters, check number formats after pasting. A date, percentage, or long number can display differently if the destination format is different, even when the underlying value copied correctly.

Troubleshooting

Excel says the copy area and paste area are not the same size: For a normal paste, click just one destination cell rather than selecting a mismatched block. If repeating a block, check that the destination rows and columns are each exact multiples of the source. Re-copy the source if the dashed outline has disappeared.

Nothing pastes: Make sure the source is still copied and the destination sheet is active. Press Copy again, click the destination, and paste. If the worksheet is protected or the destination is part of a restricted table, check Review > Unprotect Sheet if you have permission to edit it. A workbook opened in read-only mode also may not allow changes.

Only some cells appear to paste: Check whether merged cells are involved. Merged cells can prevent rectangular selections from matching cleanly. Unmerge cells where appropriate, or copy and paste a range with the same merged-cell layout. Also look for hidden rows or columns that make the visible area misleading.

Formulas show unexpected results: Normal paste adjusts relative references. Undo, then use Paste Values if you want the displayed answers, or inspect the formula references before pasting again. If formulas should keep pointing to one fixed cell, confirm the relevant reference is absolute, with dollar signs, in the original formula.

Formatting changes unexpectedly: Standard paste brings formatting from the source. Undo and use Paste Values to keep destination formatting while changing the cell contents. If you want only the appearance, choose Paste Formats from the Paste Special options instead.

The workbook becomes slow or appears frozen: Large ranges with formulas, conditional formatting, or complex styles may take time to process. Give Excel a moment, and avoid repeatedly clicking Paste. If the workbook is responsive again but the range is too large, work in smaller sections and save between batches. Check that you did not accidentally select whole columns when only part of the sheet was needed.

Frequently Asked Questions

How do I copy and paste thousands of rows quickly?
Select the exact source range with the Name Box, copy it, and click the upper-left destination cell before pasting. This avoids scrolling and repeated manual selections. If you are copying multiple columns, include them in one rectangular selection.

Can I paste the same copied range multiple times at once?
Yes. Select the full destination area and paste when its row and column dimensions are exact multiples of the copied range. For instance, a 2-by-3 source block can tile into a 6-by-12 destination. Test a small area first if the arrangement or formulas matter.

How do I copy without changing the destination formatting?
Copy the source, select the destination, and choose Home > Paste > Paste Values if you need only the contents. For formulas without source formatting, use Paste Special and select Formulas. The available paste icons can vary slightly with Excel’s ribbon layout.

Will Excel copy formulas exactly as written?
Not always. Relative references normally adjust based on the new location, while absolute references stay fixed. If you need the calculated results rather than working formulas, paste values. Always inspect a sample of the pasted formulas before filling a large area.

Can I mass paste into filtered rows only?
Be cautious: visible and hidden rows can affect the selection and paste result. If copying visible cells, use Go To Special > Visible cells only before copying, then verify the output. Pasting into a filtered list can still affect cells that are not currently visible, so use a separate range or sheet if you must preserve hidden records.

How do I undo a large paste?
Immediately press Ctrl+Z on Windows or Command+Z on Mac. Undo is safest before making other edits. If the workbook has been closed or the action is no longer available in the undo history, restore a saved copy or use the workbook’s version history if it is stored in a location that supports it.

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.