O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Find and Replace

WHEN YOU WORK WITH large workbooks, you may often find yourself wishing you could locate a specific piece of data quickly. Using Find, you can. Find allows you to search through data, formulas, and comments in a worksheet to locate the exact piece of information you are searching for. Once something is found, you can optionally replace that something with something else. In a large workbook, this feature is quite useful, as you can make massive changes throughout the workbook to the name of a product, the reported value of an investment, or any other data.

Searching for Data

As mentioned earlier, Excel can search a worksheet’s data, formulas, or comments. When searching though formulas, Excel searches not only the formulas ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required