In this tutorial, you will learn how to delete rows containing a specific value in Google Sheets
How To Delete Rows Containing Specific Value in Google Sheets
Sometimes, you may need to delete rows from your dataset that contain a certain value. For example, you may have data from a survey, and you want to delete all the entries with an answer of “Yes” for a specific question.
Luckily, we can use the Filter feature to show all the rows that contain that specific value. Once we use the filter, we will have a much easier time deleting all the affected rows at once.
In this guide, we will show you how to delete rows containing a specific value in Google Sheets.
How To Remove Rows That Have a Specific Value in Google Sheets
Here’s how to remove rows that have a specific value in Google Sheets.
Select the dataset that you want to delete rows from. Ensure that the column you want to check is part of the selection.
In this example, we have a list of employees that we want to modify. We want to remove all entries in the list where their department is listed as “Intern”.
Click on the Filter icon in the toolbar.
The headers of each column should now have a filter icon. Click on the filter icon of the relevant column that will be used as the basis for deletion.
Click the Clear button to unselect all values. Next, select the specific value which will indicate that the row is for removal. Click on OK to proceed.
In this example, we deselected all values except for “Intern”.
The filtered range should now only show all the rows that you want to delete.
Use your cursor to select all rows that are currently visible.
Right-click on the selection and click ‘Delete selected rows’.
Click on the Filter icon of the column we’ve applied a filter to earlier. Click ‘Select all’ to bring back the remaining entries. Click on OK to apply these filter options.
You have now successfully removed all rows that contained a specific value in Google Sheets.
This guide should be everything you need to delete rows containing specific values in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.