And then check the Entire row option in the popping up Delete dialog box, and click the OK button.
Go ahead to right click selected cells and select the Delete from the right-clicking menu.
See the second screenshot above.)Īnd then you can see all the cells containing the certain value are selected.Ĥ. ( Note: You can select one of searching result, and then Ctrl + A keys to select all found results. Select all searching results at the bottom of Find and Replace dialog box, and close this dialog box. In the Find and Replace dialog box, please type the certain cell value (in our case, we enter the Soe) into the Find what box, and click the Find All button. Select the range where you will remove rows based on certain cell value, and open the Find and Replace dialog box with pressing the Ctrl + F keys simultaneously.Ģ. In Excel, you can apply the powerful Find and Replace feature to remove rows based on a certain cell value easily.
