How To Delete Multiple Rows In Excel. In this article, you will get to know how to delete the contents of multiple rows in Excel, how to delete multiple rows in Excel, and how to delete multiple columns in Excel.
Microsoft Excel is the most popular spreadsheet. It includes numerous features and predefined functions. It is used to keep the information on track like business finances and data of school students. As, it is used to keep the information in order, sometimes there is a need for changes in this information. So, a user has to change or delete rows and columns frequently.
Many people are not aware of how to delete multiple rows in Excel. Here, we will discuss in detail about this topic. You will learn how to delete contents of multiple rows, multiple rows and multiple columns.
How To Delete Contents Of Multiple Rows In Excel?
To delete the contents of multiple rows in Microsoft Excel, follow the steps below:
1.Select the rows that you want to clear.
2.To do this, hold left-click and drag your mouse to select the cells of multiple rows that you want to delete.
3.Or, you can press and hold the Ctrl key and click on the cells you want to delete.
4.To clear the entire row, select the row numbers that are located on left side.
5.Hold the Ctrl key and select them with the left key.
6.Clear them by using the shortcut Delete key or right-clicking on the selected rows and select the Clear content option.
7.This will clear the content of the Excel.
How To Delete Multiple Rows In Excel?
There are various methods to delete multiple rows in Excel. Some of them are discussed below:
Method 1 – Delete Multiple Rows By Selecting Only One Cell:
To delete the multiple rows, there is no need of selecting all of them. Select only one cell of each row and use the delete menu to remove entire rows. Follow the steps below:
1.Hold the Ctrl key and click on only one of the cells from each row that you want to delete.
2.Right-click on it and select the Delete option.
3.Delete menu will get open.
4.Check the Entire row option and click on OK.
5.The rows of the selected cells will get deleted.
Method 2 – Delete Multiple Excel Rows By Using The Right-Click Context Menu:
To use the contextual menu for deleting multiple rows in Excel, follow the steps given below:
1.Open Excel.
2.Select the entire rows or cells of multiple rows that you want to delete.
3.Right-click on the selected cells to open the contextual menu.
4.Select the Delete option from the menu.
5.The selected rows will be deleted, and the other rows will take the place.
Method 3 – Delete Multiple Rows Using A Shortcut:
To delete multiple rows using a simple shortcut, follow the steps:
1.Select the rows you want to delete by holding the Ctrl key
2.Select them with the left click.
3.Press the Ctrl + – (minus) keys to delete the entire selected rows.
How To Delete Multiple Columns In Excel?
If you want to delete multiple columns, follow the above given methods. The only change you will make is instead of selecting the rows, you have to select the columns.
featured image source : techrepublic.com