Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-10-2022, 05:11 AM
ArviLaanemets ArviLaanemets is offline Deleting Multiple Rows Windows 8 Deleting Multiple Rows Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Multiple Rows Deleting rows lourid Excel Programming 5 03-15-2022 09:39 AM
VBA - Deleting Rows (criteria based) BobbyG Project 1 07-31-2017 08:55 AM
Deleting Multiple Rows Deleting rows with partially redundant data Noah14 Excel Programming 1 09-19-2014 11:46 PM
Deleting rows & pushing them up causing issues ep2002 Excel 2 08-29-2014 02:09 AM
Deleting Multiple Rows Deleting rows with specific criteria joflow21 Excel 9 11-22-2013 12:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft