Descriptive Text

Summary of all Tools

Quick Tools

Toolbox 1▾
Copy Exact Formula Copy and paste exact formula in different directions without changing cell references.
Fix Formula References Change all references to absolute.
Unfix Formula References Change all references to relative.
Add IFERROR to Formula Wrap selected cell formula in IFERROR function. You can customize the error output.
Remove IFERROR from Formula Remove IFERROR function.
Multiply by Multiply by a selected value.
Divide by Divide by a selected value.
Add Percentage of Total Divide a range of cells by a row of cells.
Add Difference Subtract a range of cells by another range of cells.
Add CAGR Add a Compound Annual Growth Rate (CAGR) formula.
Swap Formulas Between Two Ranges Swap cell contents between two ranges.
Add Text to Formula or Value Add text at the beginning and/or end of cell content.
Add Period Name Labels Insert monthly period names (Jan24, Feb24, etc.).
Add HyperLink to Cell Reference Insert a hyperlink, linking to the selected cell's first cell reference.
Bring Formula Forward Convert cell reference to the underlying formula.
Send Formula Backward Shift the contents from the cell next to the selected cell into the cell referenced in the selected cell's formula.
Fill Empty Cells with Zero Fill empty cells with zeros.
AutoFill Cells Populate empty cells by preceding non-empty cells.
Toolbox 2▾
Highlight Duplicates Highlight duplicates in a range without conditional formatting.
Highlight Differences Highlight items that exist in one range but not the other.
Insert Rows Insert a number of rows after each selected cell.
Insert Columns Insert a number of columns after each selected cell.
Apply Row Groups from Indent Apply row groups using existing indents.
Apply Indent from Row Groups Apply indent using existing row groups.
Apply Row Groups & Indent Apply row groups and indent using existing SUM/SUBTOTAL functions.
Add 'Subtotal Lines' to Row Groups Intelligently add subtotal lines (border format) that can be collapsed across an entire breakdown.
Remove 'Subtotal Lines' from Row Groups Remove subtotal line formatting.
Center Across Selection Center text horizontally without merging cells.
Trim Text Remove leading and trailing spaces.
Convert Text to Upper Case Change letters to upper case.
Convert Text to Lower Case Change letters to lower case.
Convert Text to Upper Case First Letter Change letters to lower case, except the first.
Convert Text to Upper Case Each Word Capitalize each word.
Formats▾ You can customize all formats, including adding or removing elements like fills and borders. The description below refers to the default settings.
Number Apply number formatting to selected cells.
Percent Apply percentage formatting to selected cells.
Total Row Apply total row formatting to the selected row, typically for summary totals.
Subtotal Row Apply subtotal row formatting to selected rows, ideal for intermediate totals.
Subtotal Line Add a subtotal line between groups of data.
Table Title Apply specific formatting to a table's title.
Table Header Row Apply specific formatting to a table's header row.
KPI Header Row Apply specific formatting for KPI (Key Performance Indicator) header rows.
Check Apply a check format to selected cells.
Custom 1 Apply the first custom format to selected cells.
Custom 2 Apply the second custom format to selected cells.
Custom 3 Apply the third custom format to selected cells.
Custom 4 Apply the fourth custom format to selected cells.
Custom 5 Apply the fifth custom format to selected cells.
Highlight Highlight selected cells with a specific background color.
Fill Apply a fill color to the selected cells.
Yellow Fill selected cells with yellow color.
Green Fill selected cells with green color.
Add Hierarchy Level Increase row group and indent.
Remove Hierarchy Level Decrease row group and indent.

Navigation

Explore Formula Explore a cell formula's components and navigate to precedent ranges.
Sheets Vertically navigate and rearrange sheets using drag-and-drop.
Add Text Add text at beginning and/or end of existing sheet names.
Find and Replace Find and replace text in existing sheet names.
From Selection Rename sheets based on text from cells.
Extract Sheets Extract sheets while keeping internal formulas intact.
Remove Sheets Delete sheets without breaking formulas referencing them.
Convert to Values Convert formulas to values more resource-efficiently.
Create Links Create a linked list of sheets names.
Save as Separate File Save sheets as separate Excel files.
Objects Show and navigate all charts, PivotTables, shapes, ranges with errors, ranges with conditional formats, and more, in the workbook.
Go Back Jump back to the cell that was active when a navigation tool was started.

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.
Copy Paste Σ Copy-paste only cells with SUM/SUBTOTAL formulas in a selection without overwriting other cells.
More▾
Create SUMIFS Formula Add a SUMIFS formula using convenient parameter inputs.
Create INDEX MATCH Formula Add an INDEX MATCH formula using convenient parameter inputs.
Convert SUMIFS to Cell Reference Convert SUMIFS formulas to direct cell links / SUM of direct cell links.
Convert INDEX MATCH to Cell Reference Convert INDEX MATCH formulas to direct links.
Create Indirect Sheet Reference Convert a sheet reference to an indirect sheet reference, using the INDIRECT function.
Convert and Remove INDIRECT Functions Convert indirect references to normal references.
Convert SUBTOTAL to SUM Convert SUBTOTAL formulas to SUM formulas.
Convert SUM to SUBTOTAL Convert SUM formulas to SUBTOTAL formulas.

Selections, Copy & Paste

Selection Memory Temporarily bookmark, navigate and export selections.
Add/Remove Add current selection as a bookmark / remove bookmark.
Export Options Export bookmarks as links, cell references (text) or SUM formulas.
Super Select Select cells based on whether they meet or do not meet certain conditions.
Text Select cells with certain text. Search in values and/or formulas.
Every nth Row or Column Select every nth row or column based on criteria.
Row Height / Column Width Select cells based on row height or column width.
Groups / Outline Select cells within certain groups / outline levels.
Cell/Font Colors, Indent Select cells based on cell or font color, or indentation level.
Modify Select Adjust the current selection by moving, resizing, aligning patterns, etc.
Move Move selected range(s).
Resize Resize selected range(s).
Align Pattern Align multi-range selections based on first subrange.
Transpose Switch rows and columns.
Visible Cells Select only visible cells.
Non-Blanks Select only non-blank cells.
Blanks Select only blank cells.
Copy & Paste Streamline complex copy-pasting tasks, like copying non-contiguous ranges and other actions that aren’t possible in standard Excel.
Values Paste as values.
Formulas Paste as formulas.
Constant formulas Paste as formulas (as if they were fixed).
Duplicate Paste as duplicate (same as copying a sheet and cutting the range).
Links Paste as cell link.
Cut Cut-paste.
Format Paste formats.
Row groups/outline Paste with row groups/outline.
Column groups/outline Paste with column groups/outline.

Utilities

Symbols▾ Customizable set of symbols for quick insertion.
New Sheet Insert a new sheet with customizable properties.
More▾
Sheet Links Pane to easily navigate through the same range across multiple sheets, with options to export.
Summarize Create a summary sheet with links to cells containing a specified text.
Sort Rows Sort rows in single and multi-range selections (including options to sort by absolute values).
Sort Columns Sort columns in single and multi-range selections (including options to sort by absolute values).
Group Data Group similar data such as mapping information by inserting subtotal rows/columns, including SUM/SUBTOTAL formulas.
Compare Columns Find, navigate, and insert items that exist in one list but not the other and vice versa.
Clean Workbook Settings Expand/collapse groups/outlines, select cell A1 and adjust zoom level.
Remove Defined Names Options to unhide and remove named ranges.
Trace Range Precedents Trace precedent ranges of the selected cells.
Trace Range Dependents Trace ranges dependent on the selected cells.
Trace Sheet Precedents List all sheets a selected sheet is dependent on.
Trace Sheet Dependents List all sheets dependent on a selected sheet.

PivotTables & Data Model

Convert PivotTable Automatically convert a PivotTable into grouped and formatted standard cells, preserving hierarchies and including SUM/SUBTOTAL functions.

Standard PivotTables can be converted into values, SUMIFS, or GETPIVOTDATA formulas. PowerPivots into cube formulas.
Extract, Cubes, More▾
Format PivotTable Apply common PivotDesign properties to the selected PivotTable.
Extract Sheets Without Data Model Extract sheets without 'Data Model', converting cube formulas to values.
Convert Cube Formulas to Values Convert all CUBE formulas in the selection to values.
Replace Criteria in CUBEMEMBER with Cell Reference Replace the criterion in each selected CUBEMEMBER formula with a cell reference that contains the criterion.
Replace Cell Reference in CUBEMEMBER with Criteria Replace the cell reference in each selected CUBEMEMBER formula with the criterion contained in the cell reference.
Split Nested CUBEMEMBER Functions Across Multiple Cells Split each criterion in a nested CUBEMEMBER formula into a separate cell.
Wrap N Function Around CUBEVALUE Functions Wrap all CUBEVALUE formulas in the selected cells with an N() formula to display empty cells as zeros.

Charts

Formats▾
Custom Chart Formats Customizable set of basic chart formats/properties.
Copy Colors Copy-paste colors between chart elements.
Explore Chart Navigate and modify a chart's series references.
Extend Ranges Bulk extend range references.
Reduce Ranges Bulk reduce range references.
Add Series Add multiple new series at once.
Remove Series Remove series.
Change Range References Bulk change range references.
Relink to Current Sheet Relink range references to the currently selected sheet.
Create Bridge / Waterfall Chart Quickly insert a waterfall chart linking to existing data, without populating an intermediary template.

General

Settings▾
User Profiles Setup several user profiles. All customizations are linked to a user profile.
Formats Customize format options.
Functional Settings Set IFERROR output and customize symbols.
New Sheet Customize 'New Sheet' formats.
Chart Formats Customize chart format options.
Guidance Links to website, contact form and practice files. Button to check for updates.
License Enter and activate license keys and retrieve license information.