O'Reilly logo

Excel 2003 for Starters: The Missing Manual by Matthew MacDonald

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

Find and Replace

When you're dealing with great mounds of data, it's tough to ferret out the nuggets of data you need. Fortunately, Excel's find feature is great for helping you locate numbers or text, even when they're buried within massive workbooks holding dozens of complex worksheets. And if you need to make changes to a bunch of identical items, you'll discover the find-and-replace option to be a real time-saver.

The find feature includes both simple and advanced options. In its basic version, you're only a quick keystroke combo away from a word or number you know is lurking somewhere in your data pile. With the advanced options turned on, you can do things like search for cells that have certain formatting characteristics and then apply changes automatically. The next few sections dissect these features.

The Basic Find

Excel's find feature is a little like the Go To tool described in Chapter 1, which lets you leap across a large expanse of cells in a single bound. The difference is that Go To moves to a known location, using the cell address you specify. The find feature, on the other hand, searches every cell until it finds the content you've asked Excel to look for. If you're familiar with the search feature in Microsoft Word, you'll be happy to know that Excel's search works pretty much the same way, with these few Excel-specific additions:

  • Excel searches by comparing the content you type in the "Find and Replace" dialog box with the content in each cell. For example, if you ...

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