Microsoft® Office Excel® 2007 Inside Out

Finding and Replacing Stuff

Suppose you’ve built a large worksheet and you now need to find every occurrence of a specific string of text or values in that worksheet. (In computerese, a string is defined as any continuous series of characters—text, numbers, math operators, or punctuation symbols.) You can use the Find & Select menu in the Editing group on the Home tab to locate any string, cell reference, or range name in cells or formulas on a worksheet. In addition to finding strings, you can now also find formatting, with or without strings attached. You can then click Replace to overwrite the strings or formatting you locate with new strings or new formatting.

When you click the Find command on the Find & Select menu (or press Ctrl+F), the ...