O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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 Data

With Excel's Find command, you can locate specific data, text, characters, formatting, and special characters. For example, what if you want to find the row that contains sales data for any category with the word cover in it. You can search for data in three ways:

  • Find the first occurrences of the data

  • Find other occurrences of that data

  • Find all occurrences of that data

In the next To Do exercise, you search for the first instance of the word cover.

To Do: Find Data

1.
Choose Edit, Find. Excel opens the Find and Replace dialog box.
2.
Click the Find tab, if necessary.

You can use the keyboard shortcut Ctrl+F to display the Find and ...

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