Using Find and Replace

[ LiB ]

The Excel Find and Replace feature lets you locate specific text or formulas in your worksheet and optionally replace the found data with something different.

Locating Data with Find

When you have large workbooks, sometimes it's difficult to locate specific entries. You can let Excel locate the data automatically for you.


graphic/09fig23.gif



graphic/09fig24.gif



graphic/09fig25.gif



graphic/09fig26.gif



graphic/09fig27.gif


Replacing Entries

Excel can locate specific data for you and automatically replace it with different data.


graphic/09fig28.gif



graphic/09fig29.gif



graphic/09fig30.gif



graphic/09fig31.gif


[ LiB ]


Microsoft Office Excel 2003 Fast & Easy
Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
ISBN: N/A
EAN: 2147483647
Year: 2002
Pages: 157
Authors: Olga Kokoreva

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net