The Microsoft Office Excel application is used to store and analyze data sets and has quite advanced mechanisms for working with spreadsheets. The conditions for the search function in this program can be customized in great detail to obtain the most accurate result, but this procedure does not require any special training from the user.
Necessary
Microsoft Office Excel spreadsheet editor
Instructions
Step 1
Start Excel, load the table into it and on the desired sheet, place the insertion cursor in any cell of the table. On the "Home" tab of the spreadsheet editor, by clicking on the rightmost button in the "Edit" group of commands, open the "Find and select" drop-down list. In the list of commands, select the top line - "Find". The window with the search settings, which will then appear on the screen, can also be called using the "hot keys" Ctrl + F.
Step 2
In the Find field, enter the text value that you want to find in the table. If you want to specify the search terms in more detail, click the "Options" button.
Step 3
Sometimes you need to search for a value only in cells that have some kind of special formatting - filled with a certain color, containing only text, only dates, only protected from changes, etc. Use the Format drop-down list to indicate these features.
Step 4
If the found values must exactly match the case of the entered template, select the checkbox "Match case". For an exact search, check the box "Whole cell", otherwise the values will be found in which the specified sample is only an integral part.
Step 5
By default, the search area is limited to the current sheet. If you need to expand it to the whole document, change the value in the "Look for" field.
Step 6
The specified text can be searched for both in constants or formulas, and in notes to cells - select the desired option in the "Search area" drop-down list.
Step 7
Set the search direction. By default, Excel checks from left to right all cells in the same row, then moves on to the next row. If in the field "Browse" you select the value "by columns", then the search will occur from the first cell of the column to the last, then the subsequent columns will be viewed in the same order.
Step 8
To search for one value, click the "Find Next" button, and to highlight all found cells in color, click the "Find All" button.
