Auto-search mode allows you to search column data.
To enable or disable the Auto-Search mode, do any of the following:
Press CTRL+I keys.
On the Data menu, click Auto-search mode.
Click Auto-search mode on the Data Editor toolbar.
To search for the data, select a cell in a column, and type the first letters of the required data. If you made a mistake when typing, press BACKSPACE and type the string again.
To navigate to the next entry, press CTRL+DOWN keys. To return to the previous entry, press CTRL+UP. The entries will be highlighted.