In case there is a column, which is never empty when there is anything entered into any other cell in same row:
Select the whole datarange, and from Home menu Sort & Filter. You get filter selection controls at top of datarange (in header row in case you had them, in 1st row of datarange otherwise);
Set the filter condition for column where always must be some value to '(Blanks)';
Select all filtered rows (row numbers at left of worksheet are colored blue), and delete them.
In case the is not such column (which must be always filled):
At right your datarange, into next column enter the formula like =COUNTA(A1:X1), which counts not empty cells in row, and copy this formula down for whole datarange;
Set Sort & Filter for datarange (the column with formula included);
Set the filter condition for added column to 0, and delete all filtered rows;
Delete the column with formula.
|