When running a full-text search, you also have the option to restrict what spreadsheets you want to include in the search or re-run a recent search. Search results display in the Search Results pane and the spreadsheet window, just as they do when you run a basic word search.
For more information on how to formulate an advanced full-text search, see Using search operators.
You can also click the Records menu and then click Full Text Search. If the Search field is empty and you click the Full Text Search button, the Full Text Search dialog box will open.
Notice that the Link Assistant tool is automatically turned on when you are typing. Select a short name from the list and press Enter to add the short name to your search query.
Clear the Select All check box to clear all spreadsheets and then select those that you want to include in the search.
The Search Results pane now lists all spreadsheets that include files with search hits. The number of search hits displays for each spreadsheet. The Search Results window displays records for the first spreadsheet listed. |
![]() |