View Single Post
 
Old 02-10-2020, 10:41 AM
DJ0691 DJ0691 is offline Windows 10 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