How to Delete Rows with Specific Text in Excel

To delete rows with specific text in Excel, you can use filters or the Find and Replace functionality. Here are the steps for both methods:

Method 1: Using Filters

1. Open your Excel workbook and select the worksheet containing the data you want to delete.
2. Click on the column header of the column containing the specific text you want to filter by. This will select the entire column.
3. Click on the "Home" tab in the Excel Ribbon, then click "Sort & Filter" in the Editing group, and select "Filter" from the drop-down menu. This will add filter arrows to the column headers.
4. Click the filter arrow in the column header of the column you want to filter by.
5. In the filter menu, uncheck "Select All" and then check the box next to the specific text you want to delete rows for. Click "OK" to apply the filter.
6. Select the filtered rows by clicking on the row headers. You can select multiple rows by clicking and dragging or by using the Shift or Ctrl keys while clicking.
7. Right-click on one of the selected row headers and choose "Delete Row" from the context menu. This will delete all the filtered rows with the specific text.
8. To remove the filter and show all the remaining data, click on the "Sort & Filter" option in the Home tab and select "Clear" from the drop-down menu.

Method 2: Using Find and Replace

1. Open your Excel workbook and select the worksheet containing the data you want to delete.
2. Press Ctrl + F to open the Find and Replace dialog box.
3. In the "Find what" field, enter the specific text you want to search for.
4. Click "Find All" to display a list of all the cells containing the specific text.
5. In the list of search results, click on the first item, then scroll down and hold the Shift key while clicking on the last item. This will select all the cells containing the specific text.
6. Close the Find and Replace dialog box.
7. Right-click on one of the selected cells and choose "Delete" from the context menu.
8. In the Delete dialog box, select "Entire row" and click "OK" to delete all the rows with the specific text.

Example

Deleting Rows with "Apple" as the Product Name

1. Open the Excel workbook with the data.
2. Click on the column header containing the product names (e.g., column A).
3. Follow the steps in either Method 1 or Method 2 above, using "Apple" as the specific text.
4. All rows with the product name "Apple" will be deleted from the worksheet.