How to automatically delete blank excell cells

Blank rows or Blank cells is a problem we all inherit one time or another. This is very common when you try to import data from somewhere else (like a text file or a CSV file). Today we will learn a very simple trick to delete blank rows from excel spreadsheets.

Select your data
Press F5
This opens “Go to” dialog in Excel. Now hit on that “select” button.
From “select special” screen, select “Blanks” (shown aside)
Now, all the blank cells will be selected.
Just press CTRL and Minus sign (-)
Select “shift cells up” or “entire row” as needed.

That is all. If your file is large it could take long time to finish it. Be little bit patient.

Apache Yahoo News Feed

Drupal Yahoo News

Linux Yahoo News Feed

Mysql Yahoo News Feed