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

how about filtering the column?  then you can copy the filtered rows to another sheet.

Answer 2

Simply, do the following:

• Highlight the column that you want, then click Ctrl+F as below screenshot:

• Type the value that you want to select it within the column, then click Options and check (Match entire cell contents) as below screenshot:

• Click Find All button, then Ctrl+A respectively!

• Close Find and Replace dialog box.

Now you have all the cells with a specific value selected!

Answer 3

Thanks. That does work but how can I create a second spreadsheet with only the rows with th e selected value ?

Answer 4

Thanks. That does work but how can I create a second spreadsheet with only the rows with th e selected value ?

After you select the cells, keep them selected, and click Ctrl+C to copy them, then paste them into another worksheet by Ctrl+V!

Answer 5

Thanks. That does work but how can I create a second spreadsheet with only the rows with th e selected value ?

After you select the cells, keep them selected, and click Ctrl+C to copy them, then paste them into another worksheet by Ctrl+V!

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.