Explore the many useful tools that SizzleTools’ Excel Productivity Add-in has to offer.
Take your Excel spreadsheets, models and charts to the next level with custom number formats and other tools to automate monotonous tasks. Streamline complex Excel models with tools to help linked workbooks and worksheets, formula references. Includes Formula Helpers that walk you step-by-step to create formulas such as INDEX/MATCH, Weighted Average, Percent Change.
Excel Productivity Add-In: SizzleXL
Worksheet
Name | Tool | Description |
Menu: Top-Left View | Options to set viewable top-left cell for each worksheet; A1 and Custom cell starting options | |
All Worksheets A1 | Set top-left viewable cell for each worksheet = A1 | |
All Worksheets Custom | Set top-left viewable cell for all worksheets in current workbook = user input cell | |
Selected Worksheets | Set top-left viewable cell for each worksheet in worksheet selection = user input cell | |
Worksheet Setup | Change worksheet default settings: Remove gridlines and page breaks, set print area to fit on one page, set page orientation to landscape |
Formulas
Name | Tool | Description |
Convert Values | For selected cells, Add/Subtract/Multiply/Divide per input number factor – show as values or formula – great for multiplying cells by 1 million, converting from positive to negative, etc. | |
Menu: More Formulas | Collection of formulas and helper formulas (step-by-step formula creation) | |
IFERROR | Add IFERROR to selected cells – great for getting rid of #DIV/0! errors | |
Index/Match | Helper Formula: To step through creating an Index/Match formula | |
Weighted Avg | Helper Formula: To step through creating a weighted average formula | |
% Change | Helper Formula: To step through creating an % change formula | |
CAGR | Insert CAGR formula based on selected cells [don’t worry about remembering complicated formula] | |
Triggers | Add/Remove Triggers - Adds formula to selected cells to multiply against user-selected cell [Great for modeling when you want to turn something on/off or to select between multiple scenarios] |
Number Formats
Recommended: Work with raw numbers and use customize number formats for calculations and models.
vs.
Avoid: Multiply/Divide numbers by factors and using standard number format.
(Example: You want numbers shown in thousands, so you divide cell raw numbers by 1,000 and use standard number format.)
Learn more by checking out this article: The Power of Raw Numbers: Why Precise Data Matters in Excel
Other Formats
Name | Tool | Description |
Paste Exact Formula | For selected range, copy exact formula information into the prompted range (must be same number of rows/columns as pre-selected range) | |
Menu: Copy/Paste | Options to manually copy/paste selected number formats | |
Copy Number Format | Copy selected cell's number format | |
Paste Number Format | Paste previously copied number format in destination cell | |
Menu: Cell Colors | Show cell(s) color properties | |
Show Cell Colors | Show selected cell's font, fill and border colors in RGB | |
Cell Fill Colors | Show selected cell(s) font and fill colors in RGB | |
Gray Border | For selected cell(s), change border color to gray | |
Menu: Reset | Various Cell Format Reset Options | |
Clear All Cell Formatting | For selected cells, reset all formatting | |
Clear Colors/Borders | For selected cells, reset Font, Fill and Border to default | |
Column and Row Default | For selected cells, reset column width and row height to default | |
Row Height Default | For selected cells, reset row height to default | |
Column Width Default | For selected cells, reset column width to default | |
Menu: Clean | Clean References - Options on removing same-sheet references. Example: formulas on Sheet1 =Sheet1!$A$1 converted to =$A$1 | |
Clean References Worksheet | Remove all same-sheet references throughout worksheet | |
Clean References Selection | Remove all same-sheet references for pre-selected cell(s) |
Other Useful Tools
Name | Tool | Description |
Year Qtr | For selected cells, auto-populate CY or FY quarters per prompts for starting year and quarter | |
Menu: Flip Rows/Columns | Choose to flip Columns or Rows | |
Flip Rows | For selected cells in the same column, reverse row order | |
Flip Columns | For selected cells in the same row, reverse column order | |
Menu: Rows/Columns | Color every other row/column | Insert blank rows/columns | |
Color Alt Rows | Color every other row gray | |
Color Alt Columns | Color every other column gray | |
Insert Blank Rows | Add any number of blank rows between selected cells with optional cell intervals | |
Insert Blank Columns | Add any number of blank columns between selected cells with optional cell intervals | |
Menu: Transpose | ||
Transpose Links | For selected cells, transpose and link to source cells based on a prompted starting location | |
Transpose Formulas | For selected cells, transpose cells with source formulas to a new prompted starting location | |
Transpose Values | For selected cells, transpose data values in a prompted location | |
Values Only | Convert file to values-only and save file with 'vo' extension and date/time stamp 'filename_vo_date time' [Non-destructive to source file] |
All About The Links
Name | Tool | Description |
Menu: Copy To Clipboard | Copy To Clipboard Options | |
Copy File Path | Copies Active Workbook File Name and Path Location to Clipboard | |
Copy Cell Value | Copies Active Cell's Value to Clipboard | |
Menu: External Links | Show external links for current workbook or worksheet | |
External Links in Workbook | Shows external file name(s) and path(s) for current workbook | |
External Links in Worksheet | Shows external file name(s) and path(s) for current worksheet | |
Replace Links | For selected cells, remove internal, external or TM1 links and replace cell contents with existing calculated value or zero out | |
Paste Links | For selected cells, paste links to destination cell from Left-to-Right or Top-to-Bottom | |
Sum Worksheets | For selected cells, macro will create a new sheet {Summary-Sht) and populate source cells references for ALL worksheets within workbook. [Useful when working with multiple worksheets with similar data in all worksheets] | |
Color Input Cells | For selected cells, changes font color based on: [blue] Input Value [black] Formula (same worksheet ref.) [green] External link (same workbook ref.) [red] External link (other workbook ref.) | |
Convert References | For selected cells, change formula references (absolute/relative) |
Cell Formatting
Chart Tools
Name | Tool | Description |
Menu: Chart Tools | Various Chart Tools | |
Chart Properties | Shows Selected Chart Properties | |
Series Colors | Shows Selected Chart Series Colors | |
Generate Legend | Select Chart and Create Legend, Default Or Reverse Layout | |
Menu: Data Label Options | ||
Add Default Labels | Add Data Labels (Default) | |
Add Color Labels | For all series in selected chart, add data labels and match color to series colors (font size: 9pt) | |
Color Last Point in Series | For all series in selected chart, add data labels to last series point and match font color to series color (font size: 11pt | |
Remove Last Point Labels | For all series in selected chart, remove data labels from last point only | |
Remove All Data Labels | For all series in selected chart, remove all labels | |
Properties Follow | Custom formatting and data labels FOLLOW data points as they move or change in the chart | |
Properties Don't Follow | Custom formatting and data labels DON'T FOLLOW data points as they move or change in the chart | |
Reset Plot Area | For Selected Chart: Reset Plot Area Position to Default | |
Chart Set Up | For Selected Chart: Remove Chart Title | Y-Axis | Axis Titles | Legend | Gridlines | |
Add Chart Elements | For Selected Chart: Add Chart Title | Axis Labels | Axis Titles | Legend | |
Remove Chart Elements | For Selected Chart: Remove Chart Title | Axis Labels | Axis Titles | Legend | Gridlines | |
Maximize Plot Area | For Selected Chart: Maximizes Plot Area to Fit Within Chart Area (Removing Chart Elements Will Maximize Fit) | |
Add White Borders | Add White Borders to All Series in Selected Chart | |
Remove Borders | Remove Borders from All Series in Selected Chart | |
Resize Charts | Resize Multiple Charts to Desired Height and Width | |
Resize Plot Area | Resize Plot Area of Selected Chart to Desired Height and Width | |
Don't Resize | All Charts in Worksheet Will Not be Resized with Changes to Row/Columns | |
Align Horizontal | Distribute selected shapes horizontal with custom spacing (points) | |
Align Vertical | Distribute selected shapes vertical with custom spacing (points) | |
Align Within Grid | Align selected shapes within a grid with custom spacing (points) |
Name | Tool | Description |
Capture Size & Position | Captures size and position of selection | |
Apply Size & Position | Applies size and position of new selection | |
Apply Size Only | Applies size only from capture to new selection | |
Apply Top-Left Position | Applies top-left position only from capture to new selection | |
Apply Top Position Only | Applies top position only from capture to new selection | |
Apply Left Position Only | Applies left position only from capture to new selection |
-
Excel Productivity Add-in$ 40.00