Excel 16 Delete Row Full Feature Free

Excel 16 Delete Row Full Feature Free

Full feature free trial 30-day, no credit card required Get It Now Remove rows based on multiple cell values with Kutools for Excel In some cases, you may need to remove rows based on multiple cell values from another columnlist in Excel.

It seems that there isnt a quick way to delete rows based on cell value but using VBA code.

Remove rows based on one cell value with Find and Replace function Remove rows based on one cell value with VBA code Remove rows based on one or two cell values Remove rows based on multiple cell values Remove rows based on cell value with Find and Replace feature In Excel, you can apply the powerful Find and Replace feature to remove rows based on a certain cell value easily.

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 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 all searching results at the bottom of Find and Replace dialog box, and close this dialog box.

Note: You can select one of searching result, and then Ctrl A keys to select all found results.

See the second screenshot above.) And then you can see all the cells containing the certain value are selected.

Go ahead to right click selected cells and select the Delete from the right-clicking menu.

And then check the Entire row option in the popping up Delete dialog box, and click the OK button.

Now you will see all the cells containing the certain value are removed.

See screenshots below: And then entire rows have been deleted based on the certain value already.

Remove rows based on cell value with VBA code With the following VBA code, you can quickly delete the rows with certain cell value, please do as the following steps: 1.

Press the Alt F11 keys at the same time to open Microsoft Visual Basic for applications window, 2.

Click Insert Module, and input the following code into the Module: VBA: Remove entire rows based on cell value Sub DeleteRows().

Set InputRng Application.InputBox(Range:, xTitleId, InputRng.Address, Type:8).

End Sub 3. Then click the Run button to run the code.

In the popping up dialog box, please select the range where you will remove rows based on the certain value, and click the OK button.

See screenshot: And then you will see entire rows have been deleted based on the specified value already.

Remove rows based on one or two cell values with Kutools for Excel If you have installed Kutools for Excel, its Select Specific Cells feature can help you quickly delete the rows with specific value.

Please do as follows: Kutools for Excel - Includes more than 300 handy tools for Excel.

Full feature free trial 30-day, no credit card required Get It Now 1.

Select the range that you will remove rows based on the certain value, and click Kutools Select Select Specific Cells.

See screenshot: 2.

In the opening Select Specified Cells dialog box, please check Entire row option, select Contains from Specific type drop down list, enter the specified value into right box, and click the Ok button (See above screenshot).

After applying this feature, a dialog box will pop out and show you how many cells have been found based on the specified criteria.

Please click the OK button to close it.

Now entire rows with the certain value are selected.

Please right click the selected rows, and click the Delete from the right-clicking menu.

See screenshot below: Note: This Select Specific Cells feature supports to delete rows by one or two certain values.

For deleting rows based on two specified values, please specified another value in the Specific type section of Select Specific Cells dialog box as following screenshot shown: Kutools for Excel - Includes more than 300 handy tools for Excel.

Excel 16 For Mac Delete Row