If your worksheet contains a lot of data, it can be hard to find the right cell at times. Fortunately, Excel makes it easy to search your worksheet data.
Click the Home tab.
Click the Find & Select button.
Select Find from the menu.
In the Find and Replace dialog box, enter the data you’re searching for.
Click the Find Next button to find the next instance of this data.
Tip
Replace Data In addition to simply finding data, you can also find and replace it. To do so, click the Replace tab in the Find and Replace dialog box.