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

Get Microsoft® Office Home and Student 2007 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.