O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

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

Finding and Replacing Data

Excel 2007 worksheets can contain more than one million rows of data, so it’s unlikely that you would have the time to move through a worksheet a row at a time to locate the data you want to find. You can locate specific data on an Excel 2007 worksheet by using the Find And Replace dialog box, which has two tabs (one named Find; the other named Replace) that enable you to search for cells that contain particular values. Using the controls on the Find tab finds the data you specify; using the controls on the Replace tab enables you to substitute one value for another. As an example, one of Consolidated Messenger’s customers might change the company name. If that’s the case, you can change every instance of the old name ...

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