Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-10-2020, 10:41 AM
DJ0691 DJ0691 is offline I need to delete several rows with zeros in a column Windows 10 I need to delete several rows with zeros in a column Office 2013
Novice
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default use a filter

The simple way to do a quick delete is to click on the header row and then click 'Sort & Filter' in the toolbar, then click 'Filter'. This will place a filter down arrow at the top of each column. Now filter for '0' in both the 2019 and 2018 columns.

This will leave you with just the rows you want to delete. Select those rows and hit the delete button. If you don't like the results, just do an Undo (Ctrl + z).
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
delete rows by looking at the next column if they are equal Pat.hooybergs Excel Programming 1 03-25-2018 04:13 AM
I need to delete several rows with zeros in a column Macro delete table rows if cell in first column = $ Btop Word VBA 7 02-13-2018 05:36 PM
I need to delete several rows with zeros in a column Delete blank rows between the two rows that contain data beginner Excel Programming 5 12-26-2014 12:29 AM
I need to delete several rows with zeros in a column Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 PM
I need to delete several rows with zeros in a column Eliminating zeros, null values and negatives in a column jannie Excel 1 06-22-2011 07:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:45 AM.


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