Highlight the area of your spreadsheet in which you want to delete the blank rows. Be sure to include the row just above the first blank row and the row just below the last blank row. Click “Find & Select” in the “Editing” section of the “Home” tab and select “Go To Special” on the drop-down menu. On the “Go To Special” dialog box, select “Blanks” and click “OK.” All the cells in the selection that are not blank are de-selected, leaving only the blank cells selected. In the “Cells” section of the “Home” tab, click “Delete” and then select “Delete Sheet Rows” from the drop-down menu.
All the blank rows are removed and the remaining rows are now contiguous. You can also delete blank columns using this feature. To do so, select the area containing the blank columns to be deleted. Be sure to include the column to the left of the leftmost column to be deleted and the column to the right of the rightmost column to be deleted in your selection. Again, click “Find & Select” in the “Editing” section of the “Home” tab and select “Go To Special” from the drop-down menu.
Select “Blanks” again on the “Go To Special” dialog box and click “OK.” Again, all the cells in the selection that are not blank are de-selected, leaving only the blank cells selected. This time, since there are no blank rows selected, only blank columns are selected. Click “Delete” in the “Cells” section of the “Home” tab and then select “Delete Sheet Columns” from the drop-down menu. The blank columns are deleted and the remaining columns are contiguous, just as the rows are. This method for deleting blank rows and columns is quicker, especially if you have a large workbook containing large and multiple worksheets.
![Empty Empty](/uploads/1/2/5/3/125365409/117431529.png)
Well, the problem for me is not the results of the 'blank test' per say, but rather the following: I apply the if statement to a whole row, and then I would like to use Go To - Special - Blanks to delete the blank cells from the row, i.e. The cells for which the condition was false. However, the Go to doesn't detect any blank cells in my row, specifically due to this problem that my IF statement doesn't return blank cells per-say. Therefore, I need to alter my IF statement so that it appropriately returns blank cells. – Sep 12 '13 at 15:17.
![Excel test for empty cell Excel test for empty cell](/uploads/1/2/5/3/125365409/148665135.png)
Excel for Office 365 for Mac, Excel 2019 for Mac, Excel 2016 for Mac Excel for Mac 2011 Excel contains several functions to help you count the number of cells in a range that are blank or contain certain types of data.