View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi John

check out data / filter / autofilter
go to the drop down arrow on the greetings column and choose "hello"
to get all your records back, clear the autofilter (data / filter /
autofilter) or choose data /filter / show all

Cheers
JulieD



"John Chaffey" <John wrote in message
...
Sorry about the spelling... had to make it fit.

I want to do what "edit - find" does, except print the resulting rows that
contain the cells it finds. Is there a way to do this? i.e., search for
all
rows with "hello" in a cell in column "greeting", say, then hide all the
other rows except these.

Thank you for your time on this.