Search engines are provided in most programs that work with texts. Even the browser in which you are reading this article allows you to search for a word on an open page, and even in the Word and Excel applications from the Microsoft Office suite, the search functions are brought almost to perfection. Since an Excel document is always a table, and Word documents are usually in text format, the search engines of these programs differ.
Instructions
Step 1
To find a word in a document loaded into the Microsoft Office Word word processor, use the dialog that can be invoked by the Ctrl + H keyboard shortcut. A slightly modified version of this dialog also invokes the selection of the "Advanced Search" item in the drop-down list with the inscription "Find" in the group of commands "Editing" on the "Home" tab. Enter the desired word in the "Find" field, and if you want to set additional search terms, click on the "More" button. In the additional panel opened by this button, you can set the search direction, case-sensitive, search for derived word forms, etc. To start the search, click the "Find Next" button.
Step 2
Another search method allows the background highlighting to highlight the desired word throughout the document. To activate this search mechanism, use the keyboard shortcut Ctrl + F or click on the "Find" button specified in the previous step in the "Edit" group of commands. Enter the search word in the only field of the additional "Navigation" panel, which Word adds to the left of the page with the text.
Step 3
In the document of the Microsoft Office Excel spreadsheet editor, the search dialog is also invoked by the Ctrl + F keyboard shortcut or by selecting the "Find" item in the drop-down list attached to the rightmost button on the "Home" tab. Type the word for search in the "Find" field of the appeared form. Clicking on the "Parameters" button opens additional settings, where you can specify the viewing order (by rows or columns), the search area (in the current sheet or in the entire document), viewed data (formulas or values), etc. at the moment, in the value cell, click the "Find Next" button, and to get a complete list of cell addresses with the desired word, click "Find All".
Step 4
Like Word, Excel allows you to highlight cells with the desired word. To do this, use the conditional formatting option - the drop-down list with this name has been placed in the "Styles" group of commands on the "Home" tab. Select the search area, expand this list and in the "Cell selection rules" section select the line "Text contains". In the left field of the form that opens, enter the search word, and in the right field, select the formatting option for the found cells. Click OK to start searching.
