
Once the selection is completed hit the shortcut as mentioned. Please note: Now if the columns or rows are non-consecutive, you will have to select individual rows by pressing and holding the CTRL button on your keyboard and clicking individually on the unwanted rows.
Select multiple rows in a single attemptġ] Select the unwanted rows in a single attempt on your worksheet to delete multiple rows in Microsoft Excel.Ģ] Now, press ‘ Ctrl + – ‘to delete the selection made. Here we are going to use one of the most used shortcut keys i.e. Delete multiple rows in Excel using Shortcut Now from the drop-down menu select ‘ Delete Sheet Rows’ to remove the unwanted rows.Ģ. Expand the options by clicking on the arrow button appearing next to the ‘ Delete’ option. This trick works well when you intend to delete multiple consecutive rows, follow these steps:ġ] Open Microsoft Excel sheet which has the data you wish to manipulate.Ģ] From the data, select all the rows you want to delete in one stretch.ģ] Now, right-click on the selection to open the contextual menu.ĥ] Then select ‘ Entire row’ from the delete options list and hit ‘ Ok’.Īlternatively, you can also hit the ‘ Home’ tab on the MS Excel worksheet and navigate to the ‘ Cells’ group. Delete multiple rows in Microsoft Excel through the contextual menu Read further to know how these tricks work. Delete multiple Rows by running a Macro. Deleting multiple rows in Excel by cell color. Deleting multiple rows in Microsoft Excel using Shortcut. Deleting multiple rows in Microsoft Excel through the contextual menu. You can try the following methods to delete multiple rows in Microsoft Excel, which are unwanted: In this guide, you will know the different tricks to delete multiple rows in Microsoft Excel in one go. When users deal with large data sets, there are many ways in which they can delete individual rows to even thousands of rows. While users play around with data on Excel, often they find a need to delete multiple rows in Microsoft Excel. This flexible program can also be used to build models for analyzing data, write simple and complex formulas to execute calculations on that data, pull pivot tables from the data in any possible way, and present data with professional-looking charts. MS Excel is optimized for data analysis and calculation. As a typical spreadsheet program, it allows the users to import and store large amounts of data in workbooks.
Microsoft Excel is one of the most widely used tools in any industry.