microsoft excel shortcut keys delete row

Here, our dataset shows some players’ statistics. To demonstrate this tutorial, we are going to use this dataset: It will surely develop your Excel knowledge. We recommend you learn and implement all these strategies too into your worksheets. You can use these techniques to delete a row with the shortcut. These sections will focus on a single row. In this section, we will provide you with three ways with the keyboard shortcut to delete rows in Excel. Related Content: How to Delete Row Using VBA (14 Ways)ģ Ways to Delete a Single Row in Excel Using the Keyboard Shortcut

First, press CTRL and select any cells from rows 5,7, and 9.Īs you can see, we are successful to delete multiple rows with the help of an Excel shortcut.

Here, we want to delete rows 5,7, and 9 using the Excel keyboard shortcut. Mainly, you have to choose multiple cells from the dataset to delete the entire rows. You can select numerous rows from the dataset and delete them. Similar to the previous method, you can also delete non-sequential rows with an Excel shortcut. Delete Non-sequential Rows in Excel with Keyboard Shortcut Read More: How to Delete Specific Rows in Excel (8 Quick Ways)Ģ. Press SHIFT and then DOWN ARROW twice to select the next two rows.Īs you can see, we have successfully deleted multiple rows with a simple Excel shortcut.

Next, press SHIFT+DOWN ARROW to select multiple rows.

Then, press SHIFT+SPACE After that, it will select the entire row.

First, select any cell from the dataset.

These simple steps will help you to perform this.

Now, we want to delete the last three rows from the dataset.

Microsoft excel shortcut keys delete row