How to insert and delete rows in Excel

In this lesson, we'll look at how to insert and delete rows in Excel. It's common to insert rows to make room for more information. Deleting rows is an easy way to remove information you no longer want or need.

No matter how many rows you add or delete, the number of rows in the worksheet never changes. When you insert rows, rows are pushed off the worksheet at the bottom. When you delete rows, new rows are added to the bottom.

Let's take a look.

To insert a row in Excel, first select the row below where you want the new row to be.

Then, click the Insert button on the ribbon.

Excel will always insert rows above your selection.

You can also right-click and choose Insert from the menu, which is generally faster.

If you'd like to insert multiple rows, just select more than one row before you insert. Excel will insert as many rows as you have selected.

To delete a row in Excel, first select the row you'd like to delete.

You can then delete the row using the ribbon or by right-clicking. To use the ribbon, click the Delete button.

To use your mouse, right-click and choose Delete from the menu.

You can delete multiple rows in the same way.