Copy and Paste X Times in Excel: Repeat Cells or Rows

How-to basics · Updated November 19, 2026

To copy and paste something a set number of times in Excel, copy the source cell or range, select a destination range large enough for the repeats, and press Ctrl+V. For one value or row repeated down a column, you can also select the destination cells and use Home > Fill > Down, or press Ctrl+D on Windows.

What “copy X times” means in Excel

People use “copy and paste X times” to describe a few different tasks: repeating one value in several cells, duplicating a row or a block of cells, or inserting extra copies into an existing list. The best method depends on which result you want. If you only need the same text in multiple cells, filling a selected range is usually quicker than pasting one cell at a time. If the copied block contains several columns, use a destination range with the same shape repeated as many times as needed.

For example, to put the word Pending in 20 cells, copy the cell containing Pending, select the 20 destination cells, and paste. To repeat a two-column, three-row template four times, copy that six-cell block and select a destination area that is four blocks tall and two columns wide. Excel can repeat the copied pattern across a destination selection when its dimensions fit the copied block. Selecting the right-sized area first helps prevent an incomplete or misaligned paste.

Fastest method for repeating one cell

Suppose A1 contains a label and you want it in A2 through A11. Select A1:A11 and press Ctrl+D. Fill Down takes the contents and formatting from the top row of the selected range and fills the rows below. In this example, A1 remains in place and its contents are filled through A11, giving 11 cells with the label. Alternatively, copy A1, select A2:A11, and press Ctrl+V.

You can also type a value into the first cell, select the full destination range, type the value, and press Ctrl+Enter. That enters the same value into every selected cell, without using the clipboard. This is particularly convenient when you are entering a new label rather than copying an existing cell with formatting. On a Mac, use Command+C and Command+V for copy and paste; Excel for Mac also supports Command+D for Fill Down. In Excel for the web, keyboard shortcuts can depend on the browser, so use the Home tab’s Fill command if a shortcut is intercepted.

Repeat a row or multi-cell block

To duplicate a row, copy the row’s cells rather than its row number. For example, if a template occupies A1:D1 and you want five copies beneath it, copy A1:D1, select A2:D6, and paste. To repeat a multi-row block, make the destination dimensions match the copied block multiplied by the number of repeats. If the source is A1:C2 and you want it five times vertically, the destination area should be three columns by ten rows, such as A3:C12.

After copying, Excel displays a moving border around the source. Select the destination range and paste once; you do not need to paste repeatedly by hand. Check the first and last repeated blocks afterward, especially if the source includes formulas, merged cells, or special formatting. If Excel reports that the copied area and destination area do not match, check that the destination width and height are exact multiples of the source dimensions. A two-column block cannot form complete repeated blocks in a three-column destination.

How to choose the exact number of repeats

Plan the destination size before pasting. For a single cell repeated X times, select X destination cells. For a copied block that is R rows tall and C columns wide, a vertical repeat X times needs X multiplied by R rows and C columns. A horizontal repeat needs R rows and X multiplied by C columns. For instance, a block three rows tall copied four times downward needs 12 rows in total.

Excel’s Name Box, to the left of the formula bar, can make a large selection easier. Click it, type a range such as A2:A101, and press Enter to select those cells. That range contains 100 cells, so it is suitable for filling 100 copies of a single-cell source placed above it. If your source itself should be included in the total, include it in the selection and use Fill Down, or adjust the destination range accordingly. Count whether you mean “X copies in addition to the original” or “X instances including the original”; those are different totals.

Copying formulas, values, and formatting

Copying a formula can produce different results from copying a fixed value. Excel normally adjusts relative cell references as a formula is pasted into other positions. For example, if a formula in B2 refers to A2, copying it down one row typically changes the reference to A3. That is helpful when repeating a calculation for each record, but it may be undesirable if every copy must refer to the same cell. In that case, use an absolute reference such as $A$2 in the formula before copying.

If you want repeated displayed results but not the formulas that generated them, use Paste Special and choose Values. On Windows, copy the source, select the destination, then use Home > Paste > Paste Special > Values, or open the Paste Special dialog with Ctrl+Alt+V and choose Values. The exact dialog presentation can vary by Excel build. This avoids carrying formulas into the destination. If you want the appearance but not the content, use the formatting option in Paste Special instead. Check the pasted cells when dates, number formats, borders, or conditional formatting matter, since a normal paste can bring more than just the visible text.

Copying versus filling a series

Copying the same cell repeats its content; it does not automatically create a counting sequence. If you copy the number 1 into ten cells, you generally get ten 1s, not 1 through 10. To create a sequence, enter the first two values, select both, and drag the fill handle—the small square at the bottom-right corner of the selection—downward. Excel can recognize patterns such as 1, 2, 3 or dates one day apart. You can also select a range and use Home > Fill > Series to set the step and stop value.

For a simple sequence, the fill handle is often the most direct approach. For a precise series, such as dates every seven days or numbers increasing by five, the Series dialog gives more control. Distinguish this from duplicating a template: if the row contains labels, formulas, and formatting that should be identical in each copy, copy the row. If each new entry should progress, use a series or adjust the formulas instead.

Common paste problems and how to fix them

  • The paste overwrites existing content. Pasting into occupied cells replaces their contents. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if that was not intended. To make room rather than overwrite, copy the cells, right-click the insertion point, and choose Insert Copied Cells when that option is available.
  • The pattern does not repeat evenly. The destination may not be an exact multiple of the copied block’s height and width. Re-select a range that fits complete copies, or paste one block at a time where you want a partial pattern.
  • The formulas show unexpected results. Relative references move when copied. Use absolute references for fixed inputs, and inspect one pasted formula in the formula bar before filling a large area.
  • The paste includes unwanted styling. Use Paste Special to choose Values or Formulas rather than a regular paste, depending on what you need to retain.
  • Excel will not paste. Press Esc to exit an active cell edit, confirm the source was copied, and try selecting the destination again. Merged cells can also prevent a paste when the source and destination merge patterns differ; unmerge or align the ranges before trying again.

For a large operation, save the workbook first or make a copy of the sheet. Ctrl+Z is useful for an accidental paste, but it is safer to check a small sample before filling thousands of cells. If the workbook is shared or contains important records, verify the destination range before confirming the operation.

Repeating text inside one cell is different

Sometimes “repeat X times” means displaying a piece of text multiple times inside a single cell, rather than filling multiple cells. Excel’s REPT function does that. With the text Hi in A1, enter =REPT(A1,5) in B1; B1 returns HiHiHiHiHi. This creates one text result in one cell. It does not create five cells, copy formatting, or duplicate a row. For cell-by-cell repetition, use the copy, paste, or fill methods described above.

Frequently Asked Questions

How do I copy a cell 100 times in Excel?
Copy the source cell, select 100 destination cells, and press Ctrl+V. If the source should be the first of 100 total cells, include it in the range and use Home > Fill > Down, or select the 99 cells below it before pasting.

Can Excel paste the same copied row several times at once?
Yes. Copy the row’s cells, select a destination range with the same number of columns and enough rows for the repeats, then paste. Confirm the selected dimensions form complete copies of the source.

How do I repeat a value without copying and pasting?
Type the value in the first cell, select the full range to fill, and press Ctrl+Enter. To fill downward from an existing top cell, select the range and press Ctrl+D on Windows.

Does copying a formula repeat the same answer?
Not necessarily. Excel adjusts relative references as formulas move, so each copy may calculate from a different row or column. Use absolute references such as $A$2 when a reference must stay fixed, or paste values if you want fixed results.

How can I repeat text several times in one cell?
Use REPT, for example =REPT("Go ",4) returns Go Go Go Go in one cell. Use cell filling instead if each repetition needs its own cell.

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.