Summary of all Tools
Quick Tools
Toolbox 1▾ |
|
Toolbox 2▾ |
|
Formats▾ |
You can customize all formats, including adding or removing elements like fills and borders. The description below refers to the default settings.
|
Navigation & Relationships
Sheets |
Vertically navigate and rearrange sheets using drag-and-drop.
|
||||||||||||||||
Objects | Show and navigate all charts, PivotTables, shapes, ranges with errors, ranges with conditional formats, and more, in the workbook. | ||||||||||||||||
Formula | Explore a cell formula's components and navigate to precedent ranges. | ||||||||||||||||
Go Back | Jump back to the cell that was active when a navigation tool was started. | ||||||||||||||||
Last Tool | Repeat the last used tool. | ||||||||||||||||
Trace▾ |
Assess relationships and dependencies.
|
Selections, Copy & Paste
Selection Memory |
Temporarily bookmark, navigate and export selections.
|
||||||||||||||||||
Super Select |
Select cells based on whether they meet or do not meet certain conditions.
|
||||||||||||||||||
Modify Select |
Adjust the current selection by moving, resizing, aligning patterns, etc.
|
||||||||||||||||||
Copy & Paste |
Streamline complex copy-pasting tasks, like copying non-contiguous ranges and other actions that aren’t possible in standard Excel.
|
Key Functions
Add 'Subtotal' | Add SUBTOTAL formula per shortcut (comparable to Excel's Autosum). | ||||||||||||
Add 'Sum' | Add SUM formula per shortcut. Useful if sum range and output cell are in different locations. | ||||||||||||
C&P Σ | Copy-paste only SUM/SUBTOTAL formulas. | ||||||||||||
Add 'Sumifs' | Add a SUMIFS formula using convenient parameter inputs. | ||||||||||||
Add 'IndexMatch' | Add an INDEX MATCH formula using convenient parameter inputs. | ||||||||||||
Convert▾ |
|
Utilities
Sheet Links |
Pane to easily navigate through the same range across multiple sheets.
|
||||||
Sort/Group▾ |
|
||||||
Compare | Find, navigate, and insert items that exist in one list but not the other and vice versa. | ||||||
Summarize | Create a summary sheet with links to cells containing a specified value. | ||||||
Symbols▾ | Customizable set of symbols for quick insertion. | ||||||
New Sheet | Insert a new sheet with customizable properties. | ||||||
Workbook▾ |
|
PivotTables
Convert Pivot | Automatically convert a PivotTable into a report-ready formatted standard cells, preserving hierarchies and including SUM/SUBTOTAL functions. Ideal for flexible presentation requirements. | ||||
Pivot Design | Apply common PivotDesign properties to the selected PivotTable. | ||||
Other Tools▾ |
|
Charts
Chart Formats▾ |
|
||||||||||||
Chart References |
Navigate and modify a chart's series references.
|
||||||||||||
Bridge / Waterfall Chart | Quickly insert a waterfall chart linking to existing data, without populating an intermediary template. |
General
Settings▾ |
|
||||||||||
Guidance | Links to website, contact form and practice files. Button to check for updates. | ||||||||||
License | Enter and activate license keys and retrieve license information. |