Select Rows dependant on certain field data

[Maddy]

How can I select certain rows in a spreadsheet based upon the text foun
in one column? To explain: All rows have a column that contains tex
"immediate" or "ongoing" or "closed". How can I select only the row
that contain the word "immediate" in that column?
When I say select a mean select as in ready to 'copy' or 'cut' tha
data ready to be pasted elsewhere.
I know what I mean :confused

 

[barrfly]

I would try a numbe of approaches.

1. highlight the column that has the field that you want to filter and
goto data, filter. Once the arrow appears, select the word that you
want to filter on.

2. you could sort the workbook by the column that has the field
"immediate"

Hope this helps.