Thread
:
Is thr way in Excel to "find" all cells tht cntain spcfic value, .
View Single Post
#
2
JulieD
Posts: n/a
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.
Reply With Quote