How to select & delete blank cells in between data in Excel

Select and Delete blank cells in between data in Excel. How to select blank cells to delete in between the data within a worksheet in Excel?
 
Sometimes we have a large data with some blank values and we need to delete all these blank rows or columns from the worksheet in Excel and it's not so simple to delete the blank rows and column by selecting one by one. If we have records in lacs then it might take a whole day or more or you can get frustrate too. So here is a very simple trick to select the blank cells (rows or columns) within the data and delete all those at once.

I) Put your cursor within the data range and press CTRL+G, the Go To dialog box will open then click on Special button (Alternatively you can click the 'Go To...' or 'Go to Special...' option in drop down list of Find & Select option in Editing group of Home tab).
 

II) Now Select Blanks and Hit Enter. All the blank cells within the data will be selected. 
 
III) Now press CTRL+-(minus) or Right click above any selected cells and click on Delete.
 

IV) A Delete dialog box will open with four option:

->Shift cells left
->Shift cells up
->Entire row
->Entire column

Select either shift cells up or Entire row and Hit ok.

Rememer:- There may be a discrepancy in order of your data if a single cell is blank with data in next cell, either complete row will be deleted or can change the order of your data.