Delete a Single Row or Multiple Rows in Excel

HomeExcel BasicsDelete a Single Row or Multiple Rows in Excel

Sometimes, the Excel worksheet may contain the rows of data that you want to delete to impressively represent your file. As, in this tutorial, we will go through the various methods of deleting the single, multiple (continuous, and non-continuous) rows.

Let’s understand each method one by one.

Steps to Delete a Single Row

  1. First, hover the cursor over the row header you want to delete from the worksheet.
  2. Then, press the right-click button on your mouse.
  3. From here, you need to use the delete option.
  4. Therefore, click the delete option to delete the row from the worksheet.

Steps to Delete Multiple Continues Rows

When you have to delete multiple rows at the same time in your worksheet follow the steps below:

  1. First, select all those rows that you want to remove from the row header.
  2. Next, right-click on one of the targeted rows.
  3. And now, click on the Delete option from the menu.
  4. Once you click on the delete option, you will see all the selected rows have been successfully deleted from the worksheet.

Delete Multiple Non-Continues Rows

To delete multiple non-adjacent rows from the sheet is a remarkably simple and exciting thing to do. Here, below are the steps for this:

  1. Initially, select all those non- adjacent rows one by one by the press and hold the Ctrl key.
  2. After that, move the cursor to the header of one of those rows.
  3. Now, right-click on it and click the Delete option.
  4. The moment you click delete; it will delete all selected non-continuous rows.

Delete Rows by using a Ribbon Command

Another way to delete the rows from the spreadsheet is also very time-saving and exciting. Now, below are the steps of this.

  1. To delete the row in Excel, first select (the single or multiple rows) that you would like to delete.
  2. Now, from the ribbon’s Home tab, click on the cells, and then click Delete.
  3. After that, select the Delete sheet rows option from the drop-down list.
  4. Once you click on it, you will see all the selected rows are removed from the sheet.

Important note: You can also use a shortcut that is Ctrl+ minus sign (-) from the keyboard quickly to delete the rows.

Wrap Up

So, these are the list of ways to include a shortcut to get rid of those rows you don’t want in your worksheet. In addition, it also helps you to save time and do things in a better way.

Now, tell me a thing. “Which method do you like the most?” Please write me in the below comment section, I would love to hear from you.

← Back to Main Page (Introduction to Microsoft Excel Basics – Parts, Components, and Features)

Leave a Comment