The shortcut Ctrl+F is to display the "Find and Replace" dialog box for you to quickly find the information. Same as the shortcut "Shift+F5", the default window is the "Find" box. To open the dialog box with "Replace" as the default, please use the shortcut "Ctrl+H".
Step 1: Open the worksheet and click anywhere in the worksheet;
Step 2: Press and hold the key "Ctrl" from the keyboard, then press the key "F" from the keyboard. The search box appears;
Step 3: Type the word or the phrase you want to search in the search box, e.g., "th";
– If you only need to find the next word or phrase in the workbook, please click the "Find Next" button. The cursor will move to the next cell with the word or phrase;
– If you want to find all the words or phrases in the workbook, please click the "Find All" button. The list of the records will list under the search box;
You can check the cells with the word or phrase by clicking the row in the list, and the cursor will move to the cell.