How to Add Rows in Excel with a Formula

PDF download Download Article
PDF download Download Article

Start by opening your project in Excel. Insert a row inside your data. Click to select the cell in the new row where you want to include the formula. Press Crtl + D. If you want to find the sum of two or more rows instead, see How to Sum Multiple Rows and Columns in Excel .

Method 1
Method 1 of 2:

Adding Rows to a Sheet with a Macro

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/12824869-1.jpg\/v4-460px-12824869-1.jpg","bigUrl":"\/images\/thumb\/4\/48\/12824869-1.jpg\/aid12824869-v4-728px-12824869-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    To do this, double-click the Excel document that contains your data in Finder (Macs) or File Explorer (Windows). Alternatively, if you already have Excel open, click File > Open and select the file that has your data.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/85\/12824869-2.jpg\/v4-460px-12824869-2.jpg","bigUrl":"\/images\/thumb\/8\/85\/12824869-2.jpg\/aid12824869-v4-728px-12824869-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    If it isn't and you're using Windows, go to the File tab and click Options > Customize ribbon . Under "Main tabs'" check the box next to "Developer."
    • If you're using a Mac, enable the Developer tab by clicking the Excel menu at the top of the screen and selecting Preferences . Click Ribbon & Toolbar , check the "Developer" box in the "Customize this Ribbon" category, and click Save .
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ed\/12824869-3.jpg\/v4-460px-12824869-3.jpg","bigUrl":"\/images\/thumb\/e\/ed\/12824869-3.jpg\/aid12824869-v4-728px-12824869-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    Click the Developer tab and select Visual Basic to do so. Alternatively, you can press Alt + F11 .
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f1\/12824869-4.jpg\/v4-460px-12824869-4.jpg","bigUrl":"\/images\/thumb\/f\/f1\/12824869-4.jpg\/aid12824869-v4-728px-12824869-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    In the vertical menu on the left side of the window, you'll see a list of your workbook's sheets. Right-click on any of these to get another drop-down menu.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f5\/12824869-5.jpg\/v4-460px-12824869-5.jpg","bigUrl":"\/images\/thumb\/f\/f5\/12824869-5.jpg\/aid12824869-v4-728px-12824869-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    When you hover over Insert , a menu will pop out to the right of the menu. Clicking on Module will create a space for you to enter a VBA code and run it.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1f\/12824869-6.jpg\/v4-460px-12824869-6.jpg","bigUrl":"\/images\/thumb\/1\/1f\/12824869-6.jpg\/aid12824869-v4-728px-12824869-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"} 
     Sub 
 Insert_Rows_Loop 
 () 
 Dim 
 CurrentSheet 
 As 
 Object 
 ' Loop through all selected sheets. 
 For 
 Each 
 CurrentSheet 
 In 
 ActiveWindow 
 . 
 SelectedSheets 
 ' Insert 5 rows at top of each sheet. 
 CurrentSheet 
 . 
 Range 
 ( 
 "a1:a5" 
 ). 
 EntireRow 
 . 
 Insert 
 Next 
 CurrentSheet 
 End 
 Sub
    • With this code, you'll be inserting rows starting at A1 and ending at A5—that's 5 empty new rows at the top of the sheet. [1] You can replace these cell addresses with the location into which you want to place the code, such as beginning with the last row in the sheet to any ending point.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/77\/12824869-7.jpg\/v4-460px-12824869-7.jpg","bigUrl":"\/images\/thumb\/7\/77\/12824869-7.jpg\/aid12824869-v4-728px-12824869-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    Alternatively, you can click the green Play icon above the VB editor writing space.
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/af\/12824869-8.jpg\/v4-460px-12824869-8.jpg","bigUrl":"\/images\/thumb\/a\/af\/12824869-8.jpg\/aid12824869-v4-728px-12824869-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    This adds the rows to your sheet.
    9. Advertisement
Method 2
Method 2 of 2:

Adding Formulas to New Rows

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/da\/12824869-9.jpg\/v4-460px-12824869-9.jpg","bigUrl":"\/images\/thumb\/d\/da\/12824869-9.jpg\/aid12824869-v4-728px-12824869-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    To do this, double-click the Excel document that contains your data in Finder (Macs) or File Explorer (Windows). Alternatively, if you already have Excel open, click File > Open and select the file.
    • Use this method if you want to learn how to copy existing formulas into new rows you add to your data.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0b\/12824869-10.jpg\/v4-460px-12824869-10.jpg","bigUrl":"\/images\/thumb\/0\/0b\/12824869-10.jpg\/aid12824869-v4-728px-12824869-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    Insert a row inside your data. The keyboard shortcut you'll use can only add a formula from the row above it, so make sure you insert the row in the middle or the bottom of your data collection.
    • To insert a row, right-click the row below where you want the new row to be added, then click Insert .
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/18\/12824869-11.jpg\/v4-460px-12824869-11.jpg","bigUrl":"\/images\/thumb\/1\/18\/12824869-11.jpg\/aid12824869-v4-728px-12824869-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    Remember, this keyboard shortcut will copy the formula from the cell above to the cell you have selected.
    • The cell will highlight to indicate that it is selected.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/da\/12824869-12.jpg\/v4-460px-12824869-12.jpg","bigUrl":"\/images\/thumb\/d\/da\/12824869-12.jpg\/aid12824869-v4-728px-12824869-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}
    The shortcut is the same for Mac and Windows and will fill the formula down from the cell above. [2]
    5. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Restart Your Computer Using the Keyboard
      How to
      Connect PC to TV with HDMI
      How to
      Check Browsing History on a WiFi Router
      3 Easy Ways to Find the Publication Date of a Website
      6 Ways to Pair Your JBL Earbuds: Guide & Troubleshooting Tips
      10 Genius Ways to Cheat a Step Counter on a Phone (No Walking Required)
      What Does DW Mean? Snapchat, Texting, and More
      How to Listen to Police Radio Online: Best Apps & Websites
      Easy Ways to Read Crash Dump Files & Troubleshoot Crashes
      How to
      Open a Digital Safe Without a Key
      How to
      Tell if Your Mac Is Too Old to Update
      How to Bypass Your Screen Time Passcode: Reset, Remove, or Hack Screen Time
      How to Guess a Password
      How to
      Format a Write–Protected Pen Drive
      Advertisement

      References

      1. ↑ https://docs.microsoft.com/en-US/office/troubleshoot/excel/macro-insert-delete-rows-columns
      2. ↑ https://youtu.be/JGrB0mZQLtE?t=59

      About This Article

      Article Summary X

      1. Open your project in Excel.
      2. Insert a row inside your data.
      3. Click to select the cell in the new row where you want to include the formula.
      4. Press Crtl + D .

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 64,077 times.

      Is this article up to date?

      Advertisement