Question

Excel: How to Delete Rows with Specific Text?

Answer 1

To delete rows with specific text in Excel, select the data range, open Find and Replace, enter the specific text, find all occurrences, and delete the rows.

Step-by-step explanation:

To delete rows with specific text in Excel, follow these steps:

1. Select the entire data range that you want to search for the specific text.
2. Press Ctrl + F to open the Find and Replace dialog box.
3. Enter the specific text you want to delete in the 'Find what' field.
4. Click on the Options button to expand the options.
5. Select Entire cell in the 'Look in' field.
6. Click on the Find All button to list all the occurrences of the specific text.
7. Hold down the Ctrl key and click on the row numbers of the rows you want to delete.
8. Right-click on any of the selected row numbers and choose Delete. The rows with the specific text will be deleted.

Learn more about Deleting rows with specific text in Excel