Page 83 - Excel Workbook for Dummies

08_798452 ch04.qxp 3/13/06 7:36 PM Page 66
66 Part I: Creating Spreadsheets
As soon as you close the Options dialog box, all three comments are displayed
in the worksheet. The only way to remove them from view (other than restoring
the Comment Indicator Only default setting) is to click the Hide All Comments
button on the Reviewing toolbar (which replaces the Show All Comments
button).
Hide all the comments along with the Reviewing toolbar and then save this ver-
sion of the Employee list with your notes with the filename Solved4-10.xls in your
Chapter 4 folder in the My Practice Spreadsheets folder. Now close the workbook.

Using Find and Replace and Spell-Checking

Just like Microsoft Word, Excel is equipped with a Find, Find and Replace, and Spell-
checking feature that you can use in editing your spreadsheets:

Find (Ctrl+F) enables you to search for and locate text or values in the spread-
sheet that potentially need changing.
Find and Replace (Ctrl+H) enables you select whether or not Excel replaces one
set of text or values it locates in the spreadsheet with another set that you specify.
Spelling (F7) to catch and correct spelling errors using either the built-in diction-
ary or custom dictionary you build.

Keep in mind when using Find and Find and Replace to locate entries in the spread-
sheet that you can change any of the following search options to refine the search. You
can use the

Within drop-down list box to choose between Sheet (the default) to look for the
search text only in the cells of the current worksheet or Workbook to search the
cells on all the sheets in the workbook.
Search drop-down list box to choose between By Rows (the default) to conduct
the search across the rows and then down the columns of the worksheet or By
Columns to conduct the search down each column and then across each row.
Look In drop-down list box to choose among Formulas (the default) to look for
matches to the search text in the entries as they appear on the Formula bar,
Values to look for matches in the entries as they appear in the cells of the work-
sheet, or Comments to look for matches in the comments added to the cells of
the worksheet.
Match Case check box to match the upper- and lowercase spelling in the cell
entries with the search text.
Match Entire Contents check box to match the entire contents of a cell with the
search text.
Format button to specify formatting that the cell or cell entries must match.

Try It

Exercise 4-11: Editing with Find and Replace and Spell Checking

Open the Exercise4-11.xls workbook file in the Chapter 4 folder inside your My Practice
Spreadsheets folder in My Documents on the hard disk (or in the Excel Workbook
folder on the workbook CD-ROM). This file contains a number of numeric (variations of
2500 and a variety of dates in 2006) and text (different Italian pastas, yum!) cell entries
that you can use to practice using the Find, Find and Replace, and Spell-checking fea-
tures in Excel: