Step 1 - Select the Rows you want to delete from Excel worksheet by clicking, dragging and releasing mouse pointer on its Row numbers. To delete multiple contiguous Rows from Excel worksheet, follow these steps.
HOW TO DELETE CERTAIN ROWS IN EXCEL HOW TO
Method 2 - How to delete multiple contiguous Rows from Excel worksheet If you want to delete large number of Rows, follow any of below methods. If you want to delete large number of Rows from an Excel worksheet, it is not an efficient method to delete single Row one by one. All Rows under the deleted Row are moved up by one Row, as shown in below image.īelow Animation shows how to delete single Row from Excel worksheet. The Row under deleted Row is moved up by one Row to occupy the position of deleted Row.
Step 2 - Entire 8th Row is deleted from Excel worksheet.
In this example I had selected 8th Row, by clicking on its Row number.Īnother way to achieve the same result is by running "Delete Sheet Rows" command from Excel Ribbon > "Cells" Group > "Delete" menu button as shown below. After selecting the Row number, right-click anywhere on the Row and select "Delete" from the context menu. Step 1 - Select the Row which you want to delete by clicking on its Row number. Method 1 - How to delete a single Row from Excel worksheet To delete Rows from Excel worksheet, follow any of below methods. New blank Rows (equivalent to the deleted number of Rows) will be inserted at extreme bottom of the worksheet to maintain the total number of Rows the same. When you delete Rows from Excel worksheet, the total available number of Rows in Excel worksheet do not change. In an Excel Worksheet, there are total 1048576 rows available. The Rows which you want to delete may be wrong, duplicate or irrelevant.
Sometimes Excel worksheet data may contain Rows which you want to delete.
0 kommentar(er)
