Windy.Searchlight

Dinko Gregorić, Antonio Nakić-Alfirević · Excel Extension
A package that allows you to quickly find tables, ranges and other workbook objects.

Description

Adds a modal search dialog to Excel where you can search for and navigate to various workbook objects. Searchlight opens via a keyboard shortcut – CTRL + ALT + F.
WindySearchlight
Usage

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
  • Sheets
  • Tables
  • 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