nsamonsters.blogg.se - Excel delete blank rows keyboard shortcut

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.

How to Remove Multiple Rows in Excel with Keyboard.

Delete Single Row in Excel Using Keyboard.

Go take a 15 minute break and relax, you’ve earned it. Voila! You just saved yourself a tonne of tedious work.

Hover over one of the selected cells with the mouse and left click.Ī similar trick will work for blank columns, just select Entire Column instead of Entire Row.

Now only the blank cells in the column you highlighted will be selected. You can also use the Ctrl + G keyboard shortcut to access the Go To window. If you select Go To, you will have an small extra step and take get to the Go To Special menu.

Select Go To or Go To Special from the drop down menu.

You can also use the Ctrl + Spacebar keyboard shortcut to highlight an entire column, this will highlight the column the active cell is in.

Right click on a column grid heading in your data to highlight the entire column.

Highlight a column in the data and open the Go To window. But if there were a few hundred blank rows and you wanted to delete them, that would take a while… There is a quicker way! If there are just a few rows, you could manually go through and delete them one at a time. Blank rows can make it more difficult to work with the data.

How do you quickly and easily delete blank rows or columns in your data? This is a handy trick to know if you’ve ever come across a large set of data that for some reason or other has a lot of blank rows.