[ad_1]
When working with large amounts of data in Excel or Google Sheets, even the simple task of removing all the blank cells in your worksheet could become a daunting task. Yes You have to do it manually. A quick and painless way to clean up your spreadsheet in Excel is to use the Go To Special function. This tool will help you identify all the empty cells in your document and delete them all at once. While this makes it an easy option to use, be aware that it can cause misalignment in your document. To be sure, you should forever save a backup of your document before you start deleting cells. It’s also best to delete entire rows or multiple columns to avoid messing up the order of your data.
If you use Google Sheets, you can use Filter to remove blank rows or blank cells in one column; This method also works in Excel.
How to delete blank cells in Excel using Go to special
one) Select range of cells. Highlight all the cells you want to filter.
2) Select Go To Special from the Find & Select menu. You will find the Search and Select menu on the Home tab in the Edit group. You can also press F5 and then click the Special button.
3) Select the blanks option in the pop-up menu all the blank cells in your document will be highlighted.
4) Remove selection. Right-click on any of the highlighted cells and click Remove. Choose from the removal options on the pop-up menu, then click OK.
How to delete blank rows in Excel with filter
one) Select data set range. Highlight all the cells you want to filter.
2) Navigate to the Sort & Filter menu. About him House tab in the Edition group click Sort filter and select Filter (funnel icon).
3) Filter all cells blank. Click the arrow icon for any column. In the drop-down menu, uncheck Select all and check the (Blanks) option. This will sort all the blank rows in the range you chose.
4) Remove selection. Right-click any of the highlighted cells and click Delete. Your table will look empty. Again, click the arrow icon for the column you chose and select Clear filter. All your data will reappear without the blank cells.
Note: The same process is applied to remove blank cells in a column.
Unfortunately the Go To Special command is not available in Google Sheets.
How to delete blank rows in Google Sheets
one) Select data set range. Highlight all the cells you want to filter.
2) Turn on the filter. Click on the Create a filter option of the Data tongue. Filter icons will appear in each column of the header row.
3) Filter all cells blank. Click the filter icon for any column. In the drop-down menu, click Sure, so check the (Blanks) option. This will sort all the blank cells in the range you choose.
4) Highlight blank rows.
5) The right button of the mouse in any of the highlighted cells and click Delete rows. The spreadsheet will be empty.
6) Select Disable filter from the Data tab. This will display the rest of your data.
