Delete empty data cells in Excel 2007 or 2010

TipsMake.com - In the following article, we will show you some basic actions to delete empty cells in Excel 2007 or 2010 spreadsheet. First, open the spreadsheet and press Ctrl + A to select all, or select certain data to apply:

Delete empty data cells in Excel 2007 or 2010 Picture 1

Next, press F5 , the Go To menu will display, click Special :

Delete empty data cells in Excel 2007 or 2010 Picture 2

The next Go To Special window appears, select Blanks and click OK :

Delete empty data cells in Excel 2007 or 2010 Picture 3

Then, Excel will select all blank data cells in the spreadsheet, and to delete them, press [Ctrl] [-] , the Delete window will display, select Entire Row or Entire Column to change surrounding cells and delete empty data boxes:

Delete empty data cells in Excel 2007 or 2010 Picture 4

Good luck!