In this article:

Conditionally Delete Rows in Google Sheets (Easiest Way in 2024)

May 8, 2024

How to Conditionally Delete Rows in Google Sheets

Follow the steps below to conditionally delete rows in Google Sheets. 

1. Decide Which Rows to Delete Based on a Condition

Decide on the condition that will guide which rows to delete. This could be anything from rows with a specific word, a number below a certain value, or even dates before a particular time. For our dataset, we'll delete rows where the "Status" column shows "Incomplete".

conditionally delete rows in google sheets

2. Apply a Filter to the Column Related to Your Deletion Condition

Apply a filter to the "Status" column to find rows that meet your condition. Click on the "Status" column header, then the funnel icon.

Click the column header that you're focusing on, then select the funnel icon to apply a filter. Set the filter to show only rows with "Incomplete".

3. Select Rows That Meet Your Deletion Criteria

After filtering, all rows marked as "Incomplete" will be visible. Highlight these rows by clicking on the row numbers on the left and hold down the Shift key if selecting multiple rows.

4. Delete Selected Rows That Match Your Criteria

Right-click on one of the highlighted row numbers and choose "Delete selected rows" from the context menu to remove all selected rows.

5. Turn Off the Filter to View All Remaining Data

With the "Incomplete" rows deleted, remove the filter from the "Status" column by clicking the funnel icon again, returning to the full view of your data.

6. Check Your Sheet to Confirm the Correct Rows Were Deleted

Google Sheets saves your work automatically. Check your sheet to ensure all "Incomplete" status rows have been deleted and that your dataset looks correct with the tasks that remain.

We hope that you now have a better understanding of how to conditionally delete rows in Google Sheets. If you enjoyed this article, you might also like our article on how to set up Google Sheets TEXTBEFORE or our article on how to setup RANKIF in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->