select rows with a certain value in a column

Question

I have a excel spreadsheet and want to only select rows with a specific value in a column

Answer 1

Thanks. Okay, getting close. The only thing is I want the new spreadsheet to have the entire row for the rows that have the value  selected.

To my knowledge, there is no standard technique in Excel to do that!

So we will use the VBA to accomplish this task!

• After you select the cells by using Find and Replace, keep them selected.
• Press Alt+F11 to open the VBA editor.
• Press Ctrl+G to view the immediate window as shown in the below screenshot:

• Copy this line of code to the immediate window: Selection.EntireRow.Select as below screenshot:

• In the immediate window keep the cursor in the first line and hit Enter.
• Close the VBA editor.

Now you have the entire rows with a specific value selected!

Click Ctrl+C to copy them, then paste them into another worksheet by Ctrl+V!

Answer 2

Use the Data filter tool

The results can be copied to a new sheet

Click the Filter tool to remove the dropdowns

best wishes

Answer 3

Use my solution in case you aren't able to apply the Filter, maybe the data in your sheet aren't adjacent, or the sheet is protected!

Otherwise, I recommend you to use the Filter tool as explained by Mr. Liengme in the above answer.

Answer 4

Thanks everyone for your help. I did go with the filter option as it was a little easier. It works great

Thanks again.

Dan