Delete Empty Data Cells in Excel 2007 or 2010: Instructions

This article examines Instructions and explains the main developments, practical implications, and context readers should understand.

Instructions Overview

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

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

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:

Good luck!