Delete Blank Rows/columns in excel large list with in minutes / seconds(works in Excel 2003,2007,2010)

Quick Tip : Delete Blank Rows/columns in excel large list with in minutes / seconds
 
         Preparing long list data from raw report pulled from software,bit difficult to compiles fast.
There are such a way to this activity like :

• Select blank rows/columns one by one and delete it which take more time to finish.
• Using Filter menu and Sort blanks, where you need to work again to alphabet the list.

Forget about these time consuming & Double work activity,just follow the steps to finish your work
like a lighting fast....

These are the steps to follow and check below attached pictorial too.

1. Select your Values with blanks.
2. Press F5(Go to Special)  and click special.
3. Select blanks and click OK.
4. now you can see all the empty cells are selected.
5. Delete blank cells by using Alt => h + d + r (or) Go to home => Delete cells=> Delete sheet rows.