Click on the small arrow next to the needed column name, go to Filter by Color and pick the correct cell color.Go to the Data tab in Excel and click on the Filter icon. You can use it to delete all rows that contain certain background color. The filter option allows sorting your data based on the color of cells.
How to remove rows in Excel by cell color Right-click on the highlighted range and and pick the Delete row option from the menu list.įinally click on the Filter icon again to clear it and see that the rows with the values disappeared from your table.It's not necessary to select entire rows. Select the filtered cells in the rows you want to delete.
If the list is long, just enter the necessary text in the Search field. Then uncheck the Select All option and tick the checkboxes next to the correct values. Click on the arrow icon next to the column that contains the needed items. Filter the column that contains the values for deleting by the needed text.To do this, navigate to the Data tab in Excel and click on the Filter icon. First you need to apply Filter to your table.If the items in the rows you want to remove appear only in one column, the following steps will guide you through the process of deleting the rows with such values. Delete rows that contain certain text in a single column Continue reading to find Excel VBA for deleting rows and learn how to eliminate data based on certain cell text. Hope you've found this "remove row" shortcut helpful. The additional information to the right will be left intact. Press Ctrl + - (minus on main keyboard) to see the unwanted data removed only from your table.
Please make sure you don't use the row buttons to select the entire rows. You'll see the unused rows disappear in a snap.