View Single Post
 
Old 08-10-2022, 05:11 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Reply With Quote