Goodwill Community Foundation creating
opportunities for a better life in work
books with lots of data when I'm looking
for something I sometimes have trouble
finding a specific word or phrase that I
know is in there somewhere the find
feature can help by searching the
workbook for you just click find and
select on the ribbon then choose find
and type the word or phrase you're
looking for when you're done click find
next in the dialog box if the word or
phrase is found the cell containing it
will be selected at times you may find
that you've made a mistake throughout
your workbook or you need to swap a
certain word or phrase for another for
that you can use the replace feature
instead I actually need to change the
name of this department from accounting
to finance to continue go ahead and
click replace and it will jump to the
next instance automatically if you want
to skip the current instance without
replacing it click find next instead
alternatively to replace every instance
without having to review each one click
replace all and the entire workbook will
be updated when it comes to using
replace although it's important to
remember that it could find matches you
didn't anticipate and might not want to
actually change generally speaking you
don't want to use replace all because it
doesn't give you the option of skipping
anything you don't want to change so you
should only use this option if you're
absolutely sure that it won't replace
anything you didn't intend it to now
that you know how to use Find and
Replace you can put this time-saving
technique to work in your Excel
spreadsheets