How to repeat range of cells multiple times in Excel?
As we know, you can use the copy and paste commands to repeat a range of cells in Excel, but this tutorial will tell you how to repeat a range of cells multiple times without manually copying and pasting one time by one time.
Note: the methods provided in this tutorial are tested in Excel 2021, there may be some different in different Excel verisions.
Select the range of cells that you want to repeat multiple times, then press Ctrl + C to copy it.
Then select the number of rows of selected rows' multiple, the number is based on the times you want to repeat. For example, in this case, the number of selected rows is 4, and you want to repeat the rows in 2 times, and you need to select 8 (4*2) rows to paste. Press Ctrl + V to finish the repeating.
Tip: If you want to copy the range of cells in noncontinuous cells, such as the below screenshot shows, please do as these:
1. Select the range of cells that you want to repeat, and press Ctrl + C to copy it.
2. Then select the range that contains the blank cells you want to place the repeated cells, press Ctrl + G to enable the Go To dialog, and click Special.
3. In the Go To Special dialog, click Blanks option, then click OK. Now only the blank cells are selected.
Now press Ctrl + V to paste the cells you just copied.
If you want to repeat range of cells multiple times and auto-update the data if you change, here is a formula that can help you.
For instance, here in column A of the sheet named Country lists some country names.
Now repeat the column of country names in the sheet named Repeat, please use the formula in cell A2 in sheet Repeat like this:
Press Enter key, and it will get the first country name of the list in column A of sheet Country. Drag auto fill handle down to repeat the country names.
If the original data in sheet Country changes (add or delete or change contents), the data in sheet Repeat will be auto-changed.