![is there anyway to delete certain rows in excel is there anyway to delete certain rows in excel](https://www.spreadsheetweb.com/wp-content/uploads/2018/12/Howtomakeexceldeleterowsvba.png)
Press Ctrl + - (minus on main keyboard) to see the unwanted data removed only from your table.Please make sure you don't use the row buttons to select the entire rows. You'll see the unused rows disappear in a snap. Press the Ctrl + - (minus on the main keyboard) hotkey.If you have a simple Excel list that has no additional information to the right, you can use the delete row shortcut to remove rows in 2 easy steps:
#Is there anyway to delete certain rows in excel how to
Below you'll find how to get rid of the selected lines whether you have a standard data table, or a table that has data to the right. You'll see the number of the highlighted rows next to the last button.Īfter you select the necessary rows, you can quickly remove them using an Excel "delete row" shortcut. You can also select entire lines using the row number buttons. To select the rows, you can either highlight the adjacent cells with the needed values and click Shift + Space or pick the needed non-adjacent cells keeping the Ctrl key pressed. If you want to use the fastest method of deleting multiple rows according to the cell value they contain, you need to correctly select these rows first. The fastest Excel shortcut to delete rows in your table
![is there anyway to delete certain rows in excel is there anyway to delete certain rows in excel](https://www.exceldome.com/wp-content/uploads/2018/01/Select-multiple-rows.png)