Where Is Find And Replace In Excel

Lesson ten: Using Find & Supplant

/en/excel2016/working-with-multiple-worksheets/content/

Introduction

When working with a lot of data in Excel, it tin can be hard and time consuming to locate specific information. Yous can hands search your workbook using the Find characteristic, which also allows you lot to modify content using the Supplant feature.

Optional: Download our practice workbook.

Picket the video beneath to learn more than about using Find & Replace.

To find content:

In our example, we'll use the Find command to locate a specific department in this list.

From the Home tab, click the Notice and Select command, then select Find from the drop-down menu.
The Find and Replace dialog box will appear. Enter the content you want to find. In our example, we'll type the department'southward name.
Click Find Adjacent. If the content is constitute, the cell containing that content will be selected.
Click Find Next to find further instances or Find All to run across every instance of the search term.
When you are finished, click Close to go out the Find and Supervene upon dialog box.

Yous tin can as well access the Notice command by pressing Ctrl+F on your keyboard.

Click Options to run across advanced search criteria in the Observe and Supervene upon dialog box.

Clicking options to see advanced search criteria

To replace prison cell content:

At times, yous may find that you lot've repeatedly made a mistake throughout your workbook (such as misspelling someone's proper name) or that you lot demand to exchange a particular give-and-take or phrase for another. You can use Excel's Find and Replace feature to brand quick revisions. In our example, we'll use Find and Replace to right a list of section names.

From the Dwelling tab, click the Find and Select command, then select Replace from the driblet-down menu.
The Find and Replace dialog box volition appear. Type the text you want to find in the Find what: field.
Blazon the text yous want to supplant it with in the Supervene upon with: field, then click Find Next.
If the content is found, the prison cell containing that content will exist selected.
Review the text to make sure you lot desire to replace it.
If you want to replace it, select i of the replace options. Choosing Replace volition supplant private instances, while Replace All will replace every case of the text throughout the workbook. In our example, we'll cull this option to save time.
A dialog box volition appear, confirming the number of replacements fabricated. Click OK to continue.
The selected prison cell content will be replaced.
When you are finished, click Shut to exit the Find and Replace dialog box.

By and large, it's best to avoid using Supervene upon All considering it doesn't requite you the selection of skipping anything y'all don't want to modify. You should simply use this option if you're admittedly sure it won't replace annihilation you lot didn't intend it to.

Challenge!

Open our practice workbook.
Click the Challenge tab in the lesser-left of the workbook.
Crystal Lewis was married and changed her last proper name to Taylor. Utilize Find and Replace to change Crystal's last proper noun from Lewis to Taylor. Be careful to just alter Crystal's last proper name!
Find and replace Bio with Biology. Be careful not to change the major Biomedical Engineering!
Use Observe and Replace All to supervene upon the Physics major to Physical Science.
When you're finished, your worksheet should look like this: