How to Repeat Cell Values in Excel (6 Quick Methods)

Method 1 – Copy Cell Values and Paste Directly

Steps:

Right-click on the cell to open the context menu and select Copy.

How to Repeat Cell Values in Excel

Select the cells where you want the repeat the value and right-click to open the context menu.
Select the Paste option.

How to Repeat Cell Values in Excel

Do the same thing to other cells to repeat another value.

How to Repeat Cell Values in Excel

Method 2 – Using Keyboard Shortcut to Repeat Cell Values

Case 2.1 – Ctrl + C and Ctrl + V

Steps:

Select the cell first and press Ctrl + C to copy.
Select the other cells where to paste the value and press Ctrl + V.

How to Repeat Cell Values in Excel

Case 2.2 – Combine the Go To Special Feature and Ctrl + Enter Shortcut

Steps:

Insert values to repeat at the starting cell.
Select all of the cells of the column, go to the Home tab, and select the Go To option.

How to Repeat Cell Values in Excel

A new window named Go to will open. Click on the button named Special.

How to Repeat Cell Values in Excel

A new window named Go To Special will open.
Select the Blanks option and press OK.

How to Repeat Cell Values in Excel

With the blanks selected, put “=E5” in cell E6.
Hit Ctrl + Enter on the keyboard.

How to Repeat Cell Values in Excel

All of the blank cells are filled by repeating the first cell.

How to Repeat Cell Values in Excel

Method 3 – Using a Cell Reference

Steps:

Reference the first cell E5 in cell E6 to repeat by writing:

=E5

Using Cell Reference Only

Drag the Fill Handle icon to paste the similar cell references to the last cell where you want to repeat the value.

Using Cell Reference Only

You have to do the same thing for repeating another cell using a cell reference.

Method 4 – Using the AutoFill Feature

Steps:

Click on the cell that you want to repeat.
Place the cursor on the bottom-right corner of the cell and the cursor will become a Plus icon which is called the Fill Handle.
Drag the Fill Handle icon to the last cell.
The cell value is repeated to the other cells.

Repeat Text Automatically Using AutoFill Feature

If you want to repeat another cell value, drag the Fill Handle icon again from it.

Repeat Text Automatically Using AutoFill Feature

Method 5 – Using the IF Function

Steps:

Insert the repeating values in the adjacent cells.

Using a Formula

Use a cell reference to insert the first cell value. Use this in cell E5:

=F5

Using a Formula

Apply the IF function in cell E6:

=IF(F7="",E6,F7)

Using a Formula

Drag the Fill Handle icon down.
You will get the repeated cell values in the column as your command.

Using a Formula

Method 6 – Repeat Cell Values Using VBA Code

Steps:

Go to the top ribbon and select Developer, then press on the Visual Basic option from the menu. You can also use Alt + F11.

Using VBA Code

A window named “Microsoft Visual Basic for Applications” will appear. Press on the “Insert” tab in the ribbon, then select the “Module’” option.

Using VBA Code

A new “Module” window will appear.
Paste this VBA code into the box.

Sub repeatvalues()
Dim Ran As Range
Dim Rows As Long, Cols As Long
Dim Row As Integer, Col As Integer
Set Ran = Selection
Cols = Ran.Columns.CountLarge
Rows = Ran.Rows.CountLarge
For Col = 1 To Cols
For Row = 1 To Rows - 1
If Ran.Cells(Row, Col) <> "" Then
Ran.Cells(Row, Col) = Ran.Cells(Row, Col).Value
If Ran.Cells(Row + 1, Col) = "" Then
Ran.Cells(Row + 1, Col) = Ran.Cells(Row, Col).Value
End If
End If
Next Row
Next Col
End Sub

Using VBA Code