While working in Excel, there might be a situation where you need to delete a row or multiple rows from your worksheet. In this tutorial, we will go through the various methods for this.
Let’s understand each method one by one.
Steps to Delete a Single Row
- First, hover the cursor over the row header you want to delete from the worksheet.
- Then, press the right-click button on your mouse.
- From here, you need to use the delete option.
- Therefore, click the delete option to delete the row from the worksheet.
Steps to Delete Multiple Continues Rows
If you have to delete multiple rows at once in your worksheet. Then, follow the steps below:
- First, select all the rows you want to remove from the row header.
- Next, right-click on one of the targeted rows.
- And now, click on the delete option from the menu.
- 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
Deleting multiple non-adjacent rows from the sheet is an effortless and exciting thing to do. Here, below are the steps for this:
- Initially, select all those non-adjacent rows one by one by the press and hold the Ctrl key.
- After that, move the cursor to the header of one of those rows.
- Now, right-click on it and click the Delete option.
- 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 for this.
- To delete the row in Excel, first select (the single or multiple rows) that you would like to delete.
- Now, from the ribbon’s Home tab, click on the cells, and then click Delete.
- After that, select the Delete sheet rows option from the drop-down list.
- Once you click on it, you will see all the selected rows are removed from the sheet.
You can also use the shortcut Ctrl+ (-) from the keyboard to quickly delete the rows.
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.