Finding Data

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.

Image

Image Click the Home tab.

Image Click the Find & Select button.

Image Select Find from the menu.

Image In the Find and Replace dialog box, enter the data you’re searching for.

Image Click the Find Next button to find the next instance of this data.

Image
Image
Image

Image 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.


..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset