![]() ![]() We’re starting to filter out blank rows which we’re gonna delete in a while. Then select ‘Blanks’ to filter out only the blank cells in this column. Click on the button and untick ‘Select All’. We’re gonna have a look at it together, now. Once the columns have been selected, click on ‘Data’ tab, look for ‘Sort & Filter’ and click on ‘Filter’.īuttons with an arrow appear and you’re ready to filter out what you need, in this case all blank cells, column by column. If you select just the column headers, the filter won’t work properly. Keep in mind, though, that you must select the whole columns. Select the columns you want to filter through. We’ll guide you through it step by step.įirst, we need to add a filter to the table. The advanced way we’re talking about uses the filter option. The Advanced Way How to Remove Blank Rows in Excel Let’s undo the change now and see how we can solve the task without losing the data. ![]() Find the blank cells and delete the highlighted rows and you see that our important figure has also been deleted. Let’s say that the information is very important and we can’t afford to lose it.īut this is what would happen if we did remove blank rows the way we saw in the previous tutorial. ![]() Remember the table from the previous tutorial? Row 5, specifically cell D5, contained the number 555. The problem is if one or more rows contain not only blank cells, but also cells that store some information. That quick way is safe only when all the rows you wanna delete are completely blank, so there are no data to lose. The previous video covered a general way that described how to remove blank rows in Excel.īut we can’t use it at all times. 3 How to Display the Previous Hidden Rows ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |