How To Add A Row In Excel

Every Microsoft Excel computer user should know how to add a row in Excel. You've created your first Excel spreadsheet and your are mighty proud. Unfortunately, in your haste, you realize that you forgot a row. Don't fret, you don't have to redo your entire worksheet just because you left out a row. It's easy to add a row in Excel by using the "Insert" command. The instructions below are intended for Excel Version 2002, but can be easily modified for the slight variations in other versions.

  1. Open Excel. Next open the Excel file that you need to change.
  2. Position your mouse cursor immediately below the new row that you want to add in order to add a row in Excel.
  3. Right click on that cell. You should see a list of commands.
  4. Click "Insert" from the available options. After selecting "Insert," your new row should be added above your current selected row.
  5. Save your worksheet by clicking "File" then "Save" from the toolbar. Alternatively, if your spreadsheet has already been named and saved, you can simply click the save icon located on the toolbar.
  6. In order to add more than one row in Excel, highlight two or more cells in the rows. To delete a row in Excel, you follow the same procedure for adding a row in Excel, except instead of selecting "Insert," select "Delete."
  7. If you find that you need to add or delete a column in Excel, the procedure is similar. However, instead of placing your mouse cursor below the row to be added, you want to place your mouse cursor to the right of the column to be added or deleted in Excel. Once your cursor is in the position immediately to the right of the new column you want to add or delete, click "Insert." You should now have added a column in Excel. To delete a column in Excel, follow the same procedure, except select "Delete" instead of "Insert."
  8. To add a row in Excel 2007, choose the "Home" command tab from the ribbon. Click the down arrow from the Cells group. Select "Insert Sheet Rows."  Your new row should be added above the selected cell.

Warning: don't forget to save!


University of Wisconsin-Eau Claire



What Others Are Reading Right Now.

  • 13 Things to Look Forward to in Your 30s

    You’ve probably been told that your 20s will be the best years of your life. As someone in their 30s, I can tell you honestly that nothing could be further from the truth. Here are ...

  • Speakeasy

    Acting, comedy and strong spirits converge in Speakeasy. When host Paul F. Tompkins interviews entertainers—Key and Peele, Alison Brie, Rob Delaney, Zach Galifianakis—about all sor ...

  • Follow Channel

    Remember when Seahawks cornerback Richard Sherman made all that noise—and news—before the Super Bowl? We had the story long before the season even started, trailing him all over Se ...