When using Excel press CTRL + ALT + F to open Searchlight. You can close Searchlight at any time by pressing the Escape key.
Now you can start searching for Excel objects by entering text into Searchlight. The search functionality currently uses names of the Excel objects to find matches. Searchlight will automatically try to find objects that satisfy the input and present them as items in a scrollable list below the input area.
To navigate to an Excel object simply click the corresponding item in the scrollable list or navigate to the item with the up/down arrow keys and press the Enter key. Searchlight will navigate to the object and exit on its own.
Currently supported Excel objects
- Pivot tables
- Named ranges
- Shapes (controls)
Future release ideas
- Add support for more Excel objects based on user demand
- Advanced search
- By Excel object type (e.g. find all pivot tables)
- By location (e.g. search only in sheet named Sheet1)
- Auto-navigation when hovering over or focusing item