O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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 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 choose Edit, Find to locate any string, cell reference, or range name in cells or formulas on a worksheet. In addition to strings, you can now also find formatting, with or without strings attached. You can then choose Replace to overwrite the strings or formatting you locate with new strings or new formatting.

When you choose Edit, Find (or press Ctrl+F), a dialog box like the one in Figure 7-31 appears. (If yours looks different, click Options ...

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