How to Repeat Formula for Each Row in Excel -7 Easy Methods

 

This is the sample dataset.

 

Method 1 – Dragging the Fill Handle Icon

Use the Fill Handle.

Steps:

  • Select E5.
  • Enter the following formula.

=C5*D5

  • Press Enter . You will have the formula for the first cell.

  • Select the cell again and move the mouse cursor to the bottom right end of the cell. The cursor will change as shown below.

excel repeat formula for each row

  • Click and drag the cursor to the end of the column.

excel repeat formula for each row

This will automatically repeat the formula in each row.

excel repeat formula for each row

Read More: How to Repeat Cell Values in Excel


Method 2 – Double Clicking the Fill Handle Icon

Steps:

  • Select E5.
  • Enter the following formula.

=C5*D5

  • Press Enter.

  • Select the cell again and move your cursor to the bottom right end of the selection. The cursor icon will change as shown below.

excel repeat formula for each row

  • Double-click the icon.

excel repeat formula for each row

This will repeat the formula in each row.

excel repeat formula for each row

Read More: How to Repeat Cell Value X Times in Excel


Method 3 – Applying the Down Command from the Fill Drop-Down

Steps:

  • Select E5.
  • Enter the following formula.

=C5*D5

  • Press Enter.

  • Select the range of cells in which you want the formula to be repeated. The selection should include the previous cell. Here, E5:E10.

excel repeat formula for each row

  • Go to the Home tab.
  • Click Fill in Editing
  • Choose Down.

excel repeat formula for each row

The formula will automatically be repeated in each row.

excel repeat formula for each row


Method 4 –  Copying and Pasting the Formula

Steps:

  • Select E5.
  • Enter the following formula.

=C5*D5

  • Press Enter.

  • Select the cell and press Ctrl+C.

excel repeat formula for each row

  • Select the range in which you want to repeat the formula.

excel repeat formula for each row

  • Press Ctrl+V to paste it.

excel repeat formula for each row

This will repeat the formula in each row.

excel repeat formula for each row

Read More: How to Repeat Rows in Excel Based on Cell Value


Method 5. Applying the Formula to the Entire Column

Steps:

  • Select the whole column in which you want to repeat the formula.

  • Enter the following formula.

=C5*D5

excel repeat formula for each row

  • Press Ctrl+Enter.

The formula will be applied to the whole column.

excel repeat formula for each row

Read More: How to Repeat Formula in Excel for Whole Column


Method 6 – Using Keyboard Shortcuts

Steps:

  • Select E5.
  • Enter the following formula.

=C5*D5

  • Press Enter.

  • Select the range in which you want the formula to be repeated.

  • Press Ctrl+D.

excel repeat formula for each row

The formula will be repeated in each row.

excel repeat formula for each row


Method 7 – Utilizing an Array Formula

Steps:

  • Select E5.
  • Enter the following formula.

=C5:C10*D5:D10

  • Press ‘Ctrl+Shift+Enter’ to automatically fill the cells with the formula.

excel repeat formula for each row

The formula is automatically repeated in each row.

excel repeat formula for each row


Download Practice Workbook

Download the workbook here.


Related Articles


<< Go Back to Repeat in Excel | Excel Cell Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Abrar-ur-Rahman Niloy
Abrar-ur-Rahman Niloy

Abrar-ur-Rahman Niloy, holding a B.Sc. in Naval Architecture and Marine Engineering, has contributed to Exceldemy for nearly 1.5 years. As a leader in Excel, VBA, and Content Development teams, he authored 114+ articles and assisted the Exceldemy forum. Presently, as a project writer, he prioritizes stepping out of his comfort zone, aiming for constant technical improvement. Niloy's interests encompass Excel & VBA, Pivot Table, Power Query, Python, Data Analysis, and Machine Learning libraries, showcasing his commitment to diverse... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo