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.
![easy way to delete blank rows in excel easy way to delete blank rows in excel](https://www.excel-easy.com/examples/images/delete-blank-rows/select-blanks.png)
Next, the macro simply deletes all of the visible rows that have been left by the filter. To remove the rows that have blank cells like this one, the macro first applies a filter to the product column. You can see one of those blank cells is E6. You can also use the Ctrl + G keyboard shortcut to access the Go To window. Below is an image of a data set that has some blank cells in column E (Product). 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.Step 3: Select a column and click the filter dropdown, uncheck the values excepting Blanks and click OK. Step 2: Click Home > Sort & Filter > Filter in Editing group. Tip: If you don’t see the filter buttons, go to the Table Design tab and check the box for Filter Button. Since tables can already have filter buttons in the headers, you don’t have to take an extra step to enable filters. Step 1: Select the range from which you need to remove the blank rows. To delete blank rows in your Excel table, you’ll use the filter feature. You can also use the Ctrl + Spacebar keyboard shortcut to highlight an entire column, this will highlight the column the active cell is in. Method 2: Eliminate blank rows by Excel filter functionality. 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.
![easy way to delete blank rows in excel easy way to delete blank rows in excel](https://blog.faradars.org/wp-content/uploads/2020/09/Remove-Blank-Rows-in-Excel-the-Easy-Way.jpg)
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! Excel sets out your data so nicelyand then its hard work is interrupted by blank rows. There’s something inherently irritating about spreadsheets with blank rows. Written by co-founder Kasper Langmann, Microsoft Office Specialist.
EASY WAY TO DELETE BLANK ROWS IN EXCEL HOW TO
If there are just a few rows, you could manually go through and delete them one at a time. How to Delete Blank Rows in Excel The Right Way. 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.