Table of Contents
Deleting rows with specific text in Excel can be done in a few simple steps. First, select the rows that contain the specific text you want to delete. Then, right-click on one of the selected rows and choose “Delete” from the drop-down menu. This will prompt a dialog box to appear, where you can select to delete the entire row or just the contents of the cells. Select the desired option and click “OK” to delete the rows. Alternatively, you can also use the “Find and Replace” function to search for the specific text and delete all rows containing it. This can be accessed by pressing “Ctrl+F” and typing in the text to be deleted in the “Find what” field, then leaving the “Replace with” field blank and clicking “Replace All”. This method will delete all rows containing the specific text. By following these steps, you can easily delete rows with specific text in Excel and efficiently manage your data.
Excel: Delete Rows with Specific Text
The following step-by-step example shows how to delete all rows in Excel that contain specific text.
Step 1: Create the Data
First, let’s create a dataset that shows the ratings of three players on different basketball teams:
Step 2: Find Values with Specific Text
Suppose we would like to delete every row that contains Bad as one of the ratings.
On the Home tab, click the Find & Select icon and then click Find from the dropdown menu:
In the new window that appears, type Bad into the search box and then click Find All.
Then click Ctrl+A to highlight all of the cells that contain the text Bad. Then click Close.
All of the cells that contain Bad will be highlighted.
Step 3: Delete Rows with Specific Text
Next, click the Delete icon on the Home tab and then select Delete Sheet Rows from the dropdown menu:
All of the rows that contained Bad in one of the cells will automatically be deleted:
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How do I delete rows with specific text in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-delete-rows-with-specific-text-in-excel/
stats writer. "How do I delete rows with specific text in Excel?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-delete-rows-with-specific-text-in-excel/.
stats writer. "How do I delete rows with specific text in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-delete-rows-with-specific-text-in-excel/.
stats writer (2024) 'How do I delete rows with specific text in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-delete-rows-with-specific-text-in-excel/.
[1] stats writer, "How do I delete rows with specific text in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I delete rows with specific text in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.