How to search, find and replace in all open Excel workbooks

You can watch the full-size original video here:
http://www.ablebits.com/excel-find-re...

This video shows how you can quickly find and replace multiple values, formulas, comments and hyperlinks in all opened Excel worksheets using Advanced Find & Replace for Microsoft Excel add-in.

Unlike the Standard Excel Find, the Advanced Find & Replace add-in displays all search results in a tree, its pane is nested neatly in the left part of your Microsoft Excel workbook and the search results will never overlap your data.

The video demonstrates that finding and replacing all addresses with a particular domain name in a large worksheet literally takes no longer than a few seconds. It also shows some advanced options like exporting search results.

Find more about Advanced Find & Replace for Microsoft Excel here:
http://www.ablebits.com/excel-find-re...

---

Closed Caption:

this video will show you how advanced
Find and Replace can help you quickly
find and replace multiple values
formulas comments and happenings in
different workbooks
you'll also see what advantages that and
keep she compared to the standard itself
and future
to start working within 10 go to it will
be sent comp lab
and play can find and replace taken you
can also start beatin by clicking the
standard control and death
hotkey you can always switch to control
out and if you like
the best advantage if they had any
status display it is a pain but you can
see to the left to the workbook
that he will oversee the search results
and the standards which one will not
cover your data
the second advantage is the possibility
of simultaneous said
in also opened book books you can see
all open workbooks and purchase and the
pain
and you can select the ones you want to
say HM the dead advantage of their 10
is their ability to Sachin values
formulas commenting happenings at the
same time
imagine that you received a message from
a customer who said that the email
addresses in his company
a changed from at some company dot com
to at new cool name dot com you have
many clients from this company
and you need to update all the email
addresses you can see that we have
opened three what perks
orders 2010-11 customers 2011
and customers 2010 but we only one
such into them separately check all
and and select the workbook that we
don't want to Sachin at the moment
usually the address is there's a tax but
it may also be a hyperlink
you can be found in Commons a fun night
as well so select all these options to
make sure to find everything
into the find what failed wear and tear
some company dot com and click Find all
button in a couple of seconds you will
see all the search results in 103
let's look at the results when
handwritten entry in the search result
the end in the Big East its original
location and selected in your work sched
you'll immediately see where executive
and data are located
nuts to place the pan values for the new
one
we enter new cool name dot com
into their replacement failed if you'd
like to replace the old values
only in some particular cells select
them in the search results
you can do this by holding control
button and selecting them using a mouse
then click Replace as many to replace
all the values weekly replace all in a
couple of seconds
all the email addresses are updated in
all workbooks
now would like to customize that we know
about the new domain name
and that we have updated their email
addresses in our database
send emails many to list at the client's
names and email addresses
will use the option to export our
session replacement results you can see
the export
all buttoned at the bottom of the pain
they default to create a new workbook
with
all search results you can also expand
this say
the expect to rows and columns that
contain the fan values
or by highlighting some entries you can
also
exploit them or the rows and columns
that contain them
advanced find a new place is also
pending everyday work when you need to
quickly find something in a column
usually result a filter for this purpose
but it prevents us from seeing adjacent
rows that may contain important
information
when you spend its search feature you
can see how many items are found to be
set using
fine next if you said you can find all
the phone with the results I was the
table with your data
this is for now added makes it easy
heard something you to find all
customers from Phoenix
all you do is select city column in
start headin
and Phoenix undefined what field and
Kylie
find all at the second she said
yourselves
thank you for your attention he have any
other questions about their day in
feel free to contact us at support able
be stuck com