Step 1: Select the Entire Row Using “SHIFT SPACE”įollow the same key shortcut “SHIFT SPACE” as you have used above. You can also delete the multiple numbers of rows fastly using the step given below. In addition to the above method of deleting the single row in Excel. How to Remove Multiple Rows in Excel with Keyboard If you have any doubt for the keys, you can check the below-given image showing the keys to press together. This will immediately remove the selected row on pressing of the required keys. Step 2: Final Step: Delete Selected Rows Using “CTRL -“įinally, use your keyboard again and press a new shortcut key “CTRL -“. See the image below showing the buttons to press in combination. You will get the single rows highlighted and selected after you press this shortcut. Press the keyboard shortcut “SHIFT SPACE” to the cell the entire row. Step 1: Select the Entire Row Using “SHIFT SPACE” This is a 2 step method and the fastest method to select and remove the row.įirst of all, use your keyboard left-right arrow to go the cell of the row which you want to delete. The method is useful when you want to delete only the single row in excel. Other Option to Delete Selected Rows in Excelĭelete Single Row in Excel Using Keyboard.
0 Comments
Leave a Reply. |