All language subtitles for 4. Finding and Replacing Data in your Worksheet

In this video we even find cells with specific information Excel worksheets can hold more than one million

rows of data which makes it extremely difficult to manually look through a worksheet to locate the data.

We're trying to find Excel has multiple options to help you find the data you are looking for in a vault

sheet auto loan book in the editing group click find and select tool from the dropdown list you can

select.

You don't find all the bliss you can locate specific data in an Excel worksheet by using find use replays

to replace a text or number in one or more cells put something else.

Then you select either find or replace Excel opens refined and replace dialog box in the Find what text

entry box.

Let us into me.

If you click find all Excel looks through the vote sheet and find all the instances of the text or number

you typed in the text box.

If you click find next Excel finds the next occurrence of the text or number and stops by default Excel

find cells with content that even partially matches the text on number you enter in they'll find what

box click the options button to reveal.

Find options you can specify whether you want to search within the current sheet or on all worksheets

in a vote book.

You can search by rows ordered by columns you can look in formulas values or comments.

You can also search for content that matches the gaze of the content you and Dad in indeed find what

box.

If you select the match entire self-contained state box Excel finds only those cells where the content

completely matches the text or number you also think for let this click find next that goes so most

to cell 8 as it finds a match sometimes we want to replace some content in the vote sheet let us replace

total sales with total underscore since to do so click the replace tab type.

Total sales in the Find what text entry box

type.

Total on this course is in the replace with text entry box click the replace all button Excel makes

1 replacement as it finds 1 match click Okay click close on the Find and Replace dialog box.