Microsoft Office Tutorials and References
In Depth Information
The Find and Replace Commands
When you distribute a workbook as a PDF or XPS ﬁ le, those who want to read the
workbook must have a reader program installed. The most common PDF reader is Acrobat
Reader from Adobe. Microsoft provides a reader for its newer XPS ﬁ le format.
To save a workbook in the PDF and XPS ﬁ le formats, you must install an add-on
program from Microsoft’s Web site. The add-on program is available as a free download
from Microsoft, and a link to the Web site is provided in Excel Help. Once installed, the Save
As submenu on the Ofﬁ ce Button menu includes a new PDF or XPS command. When you
click the command, Excel displays the Publish as PDF or XPS dialog box which allows you to
choose a ﬁ le name for the document, a location to save the document, and other options.
The Find Command
If you want to search
only a speciﬁ ed range
of a worksheet, then
select the range before
invoking the Find
command. The range can
consist of adjacent cells
or nonadjacent cells.
A string can be a single character, a word, or a phrase in a cell on a worksheet. You display
the Find & Select menu by clicking the Find & Select button on the Ribbon. The Find
command on the Find & Select menu is used to locate a string. The Replace command
on the Find & Select menu is used to locate one string and then replace it with another
string. The Find and Replace commands are not available for a chart sheet.
Both the Find and Replace commands cause the Find and Replace dialog box to be
displayed. The Find and Replace dialog box has two variations. One version displays mini-
mal options, while the other version displays all of the available options. When you invoke
the Find or Replace command, Excel displays the dialog box variation that was used the
last time either command was invoked.
The following steps show how to locate the string, Toshiba, in the four worksheets: Company, Louisville,
Kansas City, and Portland. The Find and Replace dialog box that displays all the options will be used to customize
the search to include the entire workbook and to use the match case and match entire cell contents options. Match
case means that the search is case sensitive and the cell contents must match the word exactly the way it is typed.
Match entire cell contents means that the string cannot be part of another word or phrase and must be unique
in the cell. Unlike the Spelling command, which starts the spell checker at the active cell and works downward, the
Find and Replace commands always begin at cell A1, regardless of the location of the active cell.
• Click the Home tab on the Ribbon.
Find & Select
• With the Company sheet active,
click the Find & Select button on
the Ribbon (Figure 6–77).
Find & Select menu