Skip to Main Content
Excel 2003 for Starters: The Missing Manual
book

Excel 2003 for Starters: The Missing Manual

by Matthew MacDonald
October 2005
Beginner content levelBeginner
400 pages
8h 53m
English
O'Reilly Media, Inc.
Content preview from Excel 2003 for Starters: The Missing Manual

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Show Me Microsoft® Office Excel 2003

Show Me Microsoft® Office Excel 2003

Steve Johnson - Perspection, Inc.

Publisher Resources

ISBN: 0596101546Supplemental ContentErrata Page