Inserting and Deleting Rows in Excel 2013

When you are adding data to a spreadsheet in Microsoft Excel, it’s pretty common to either add some data that you wind up not needing or to forget about something and need to add it at a later time.

Fortunately, there are options in Excel that allow you to insert or delete entire rows from your spreadsheet.

Below is a video that provides more information on inserting or deleting rows in Microsoft Excel. We also discuss the steps for managing the rows in your worksheet in additional sections in this guide.

Webucator, a leader in online and onsite training courses, just created a great video that walks you through the process of inserting and deleting rows in a Microsoft Excel 2013 spreadsheet.

The video is very well done, and is presented in an effective way to help anyone that is looking to learn more about managing the rows in an Excel worksheet. The video that they created is below.

For additional helpful Excel videos like this, you can visit Webucator’s website to check out more of their Microsoft Excel classes.

They provide a large selection of training courses that are beneficial to a wide range of Excel skill levels, while also offering courses for users of Excel 2007, Excel 2010, Excel 2013, and Excel 2016.

If you would like to read the articles featured in the video above, simply click one of the links below.

How to Insert a Row in Excel 2013

How to Delete a Row in Excel 2013

Summary of Video on Managing Rows in Excel

Working with data in a Microsoft Excel worksheet often involves adding and deleting data in the cells that you have included in your worksheet.

You might have already figured out how to delete data from a cell, or how ot edit the data inside of a cell if you’ve made a mistake, but you can also choose to manage the rows and columns in the spreadsheet as well.

One way that you can do this is via the navigational ribbon at the top of the screen.

If you click on a row number on the left side of the sheet, or a column letter at the top of the sheet, it is going to select that entire range of cells.

You can then click the Home tab, then choose the Insert or Delete options in the Cells group in the ribbon.

Alternatively, you can right-click on a selected row or column, then choose the Insert or Delete option from that shortcut menu.

More Information on Inserting Rows in Microsoft Excel

While the default structure in Microsoft Excel provides you with a lot of empty rows at the bottom of the sheet, it’s not very useful when you need to include a row in between some data that you have already added ot your spreadsheet.

If you need to add an additional row in between some rows that already contain data, then you can use these steps.

  1. Open your Excel spreadsheet.
  2. Right-click on the row under where you want the new row.
  3. Choose the Insert option.
how to insert a row in Excel

The next section discusses deleting a row in your spreadsheet that contains data that you no longer need.

More Information on Deleting Rows in Microsoft Excel

Just as important as adding new rows to a spreadsheet is the ability ot get rid of rows in Microsoft Excel.

You may have already figured out how to remove the data from a cell by selecting it then pressing the Delete key or the Backspace key on your keyboard, but that will only get rid of the data in the cells, it won’t remove the cells themselves.

You can follow these delete row Excel steps to completely remove all of the cells and content in a single row of your spreadsheet.

  1. Open your worksheet in Microsoft Excel.
  2. Right-click on the row that you want to delete from the spreadsheet.
  3. Choose the Delete option.
how to delete a row in excel

Note that you can select multiple rows at once by clicking on one row, then holding down the Ctrl key and clicking other rows.

Once you have selected all of the rows that you would like to delete you can right-click on any of them and choose the Delete option to delete those multiple rows.

Related Guides

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy

Newest Guides