Features

Tracing

Icon	Function	Description	Shortcut
	Trace Precedents	Show all cells that the selected cell depends on by drawing blue arrows to precedent cells. Helps identify formula dependencies and data flow.	Alt + X + C
	Trace Dependents	Show all cells that depend on the selected cell by drawing red arrows to dependent cells. Useful for impact analysis when changing values.	Alt + X + D
	Revert Backwards	Return to the original cell prior to tracing so you can resume work without losing context.	—
	Precedent Arrows	Show precedent arrows for the active cell, drilling deeper with repeat presses to trace complex formula chains.	Alt + X + P
	Remove Precedent Arrows	Clear every precedent and dependent arrow from the active worksheet with one click.	—
	Dependent Arrows	Toggle dependent arrows for the selected cell to see which formulas consume its output.	Alt + X + P
	Remove Dependent Arrows	Remove every dependent and precedent arrow to reset the worksheet view instantly.	—

Formulas

Formula Tools

Icon	Function	Description	Shortcut
	Magnitude (+)	Multiply selected numbers by 10 to scale results upward without rewriting formulas.	Alt + X + P
	Magnitude (–)	Divide selected numbers by 10 to scale results down while preserving precision.	Alt + X + M
	Flip Sign	Switch positive values to negative (and vice versa) across the selection for rapid scenario changes.	Alt + X + F
	Fill Right	Copy the leftmost cell's value or formula to every cell on the right with intelligent relative references.	Alt + X + R
	Fill Down	Copy the top cell through the selection below, respecting smart referencing for efficient fills.	Alt + X + D
	Wrap (NA)	Encapsulate formulas with IFERROR and return #N/A on failure to keep audit trails intact.	Alt + X + N
	Wrap (0)	Wrap formulas with IFERROR and return zero on error to prevent errant spillover in models.	Alt + X + Z
	Convert → LET	Refactor complex expressions into the LET function for cleaner logic and reusable calculations.	Alt + X + L
	Formula Wrap	Apply common wrappers or parenthesis structures to formulas to standardize presentation.	Alt + X + W
	Solve Formula	Evaluate formulas step by step to view intermediate calculations and debug quickly.	Alt + X + S
	Anchor Cycle	Cycle references between relative, absolute, and mixed anchors without touching the keyboard.	Alt + X + A

Paste Tools

Icon	Function	Description	Shortcut
	Exact Formulas	Paste formulas exactly as copied without adjusting references, perfect for audit-safe moves.	Alt + X + E
	Smart Exact	Intelligently paste a mix of absolute and relative references to preserve intent across ranges.	Alt + X + D
	Number Format	Transfer only number formatting from the copied cells while leaving values and formulas untouched.	Alt + X + N
	Fill Color	Paste just the background fill colors to harmonize table styling in seconds.	Alt + X + F
	Range Border	Copy border formatting for consistent outlines and separators across your model.	Alt + X + B
	Column Width	Match column widths to the source selection so reports stay aligned without manual resizing.	Alt + X + W
	Row Height	Copy row heights from the source range to maintain consistent spacing and layout.	Alt + X + H

Formatting

Brand Format

Icon	Function	Description	Shortcut
	Company Format	Apply the firm's default styling to selected tables and charts for instant on-brand visuals.	—
	Chart Format	Restyle charts with the standard brand color palette, fonts, and line treatments.	—
	Table Format	Reformat selected ranges into the approved table style without touching native Excel themes.	—
	Brand Fill Color Cycle	Cycle through the brand’s primary fills for shapes, charts, and table headers.	—
	Brand Border Color Cycle	Rotate border colors through approved brand accents to differentiate tables and shapes.	—
	Brand Font Color Cycle	Cycle text through brand-approved colors to establish hierarchy and emphasis.	—

Number Formats

Icon	Function	Description	Shortcut
	Number Cycle	Cycle common number formats such as general, thousands, and decimal layouts.	Alt + X + N
	Currency Cycle	Rotate through currency formats including accounting layouts and precision variants.	Alt + X + Y + B
	Percent Cycle	Toggle percentage formats with different decimal positions to match presentation needs.	Alt + X + P
	Date Cycle	Cycle through date stamps such as MM/DD/YYYY, DD-MMM-YY, and long-form styles.	Alt + X + D
	Multiple Cycle	Display values as multiples (e.g., 1.2x) by rotating through pre-built multiplier formats.	Alt + X + M
	Binary Cycle	Cycle between binary, hexadecimal, and related technical number representations.	Alt + X + B
	Decimals (+)	Increase the number of visible decimal places to add precision.	Alt + X + L
	Decimals (–)	Reduce the number of visible decimal places for cleaner summaries.	Alt + X + S

Font Colors

Icon	Function	Description	Shortcut
	Blue Black Cycle	Toggle input versus calculation colors for models by cycling blue and black fonts.	Alt + X + B
	Model Color Cycle	Apply the standard modeling color scheme (inputs, calculations, links, warnings).	Alt + X + M
	Auto Color Selection	Assign appropriate font colors based on whether a cell contains a constant, formula, or link.	Alt + X + A

Fill Colors

Icon	Function	Description	Shortcut
	Auto-Table Color	Apply alternating row colors with branded hues to instantly format tables.	Alt + X + A
	Model Fill Color Cycle	Rotate fills through the current document theme for consistent visuals.	Alt + X + T
	Theme Color Cycle	Move elements through theme colors to highlight key data without breaking brand rules.	Alt + X + T

Other Cycles

Icon	Function	Description	Shortcut
	Underline Cycle	Rotate through no underline, single, double, and accounting underline styles.	Alt + X + U
	Border Cycle	Cycle common border combinations such as outline, full grid, and custom patterns.	Alt + X + B
	Font Size Cycle	Rotate fonts through the standard size ladder (8–18pt) for quick hierarchy updates.	Alt + X + F
	Row Height Cycle	Step through preset row heights to tighten or loosen spacing.	Alt + X + H
	Column Width Cycle	Rotate through standard column widths to align reports and schedules.	Alt + X + W
	Footnote Cycle	Cycle footnote formatting styles with superscripts and reference formatting.	Alt + X + N
	Remove Footnotes	Strip all footnote formatting and references from the selection or worksheet.	Alt + X + R

Format Tools

Icon	Function	Description	Shortcut
	List Bullets	Add bullet points to selected cells to create readable lists inside Excel.	Alt + X + L
	Accounting Dots	Insert accounting leader dots for neatly aligned financial statements.	Alt + X + A
	Sum Line	Apply single or double underlines to totals for a polished financial finish.	Alt + X + S
	Left Indent	Increase left indent to establish hierarchy inside tables and line items.	Alt + X + I
	Right Indent	Increase right indent for better alignment of commentary or notes.	Alt + X + R
	Transparent → White	Convert transparent fills to white to avoid unexpected rendering in exports.	Alt + X + T

Range Tools

Icon	Function	Description	Shortcut
	Merge-Center Across	Merge cells horizontally and center text while keeping row structure intact.	Alt + X + M
	Hide → Group	Convert hidden rows or columns into collapsible outline groups for easier navigation.	Alt + X + G
	Reverse Columns	Flip the order of selected columns from left to right without manual rework.	Alt + X + Y + D
	Reverse Rows	Flip the order of selected rows from top to bottom to reorganize data quickly.	Alt + X + R
	Delete Blank Columns	Remove empty columns in the selection or sheet to tighten layouts.	Alt + X + D
	Delete Blank Rows	Remove empty rows to compress schedules and speed up printing.	Alt + X + B
	Hardcode Selection	Convert formulas into values while preserving outputs in the selection or used range.	Alt + X + H
	Calculate CAGR	Insert a CAGR formula for the selected data to quantify growth rates automatically.	Alt + X + A

Sizing Tools

Icon	Function	Description	Shortcut
	PPT Guides	Display alignment guides and gridlines to position shapes precisely.	Alt + X + G
	Resize to PPT	Resize selections to PowerPoint-friendly dimensions for seamless copy/paste.	Alt + X + R
	Auto Grid	Arrange selected objects into a clean grid with uniform spacing.	Alt + X + A
	Same Width	Match object widths to the first selection to ensure consistency.	Alt + X + W
	Same Height	Match object heights to the first selection for uniform sizing.	Alt + X + H
	Same Width and Height	Set all selected objects to the same width and height at once.	Alt + X + S
	Extend Left	Extend objects left to align with the furthest left selection edge.	Alt + X + L
	Extend Right	Extend objects right to align with the furthest right selection edge.	Alt + X + E
	Extend Top	Extend objects upward to align with the highest selection point.	Alt + X + T
	Extend Bottom	Extend objects downward to align with the lowest selection point.	Alt + X + B
	Fit Horizontal	Resize objects to fit across the available width without breaking proportions.	Alt + X + F
	Fit Vertical	Resize objects to fit the available height while keeping aspect ratio.	Alt + X + V

Shape Alignment

Icon	Function	Description	Shortcut
	Align Left	Align the left edges of all selected objects with the leftmost object.	Alt + X + L
	Align Right	Align the right edges of all selected objects with the rightmost object.	Alt + X + R
	Align Middle	Align object centers vertically for perfect middle alignment.	Alt + X + M
	Align Top	Align top edges to the highest object for a clean baseline.	Alt + X + T
	Align Bottom	Align bottom edges to the lowest object to finalize spacing.	Alt + X + B
	Align Center	Align horizontal centers with a single command for perfectly balanced layouts.	Alt + X + Y + F
	Distribute Horizontal	Distribute objects evenly across the horizontal axis with equal spacing.	Alt + X + H
	Distribute Vertical	Distribute objects evenly across the vertical axis to level layouts.	Alt + X + V
	Snap Together	Snap selected objects together for tightly grouped arrangements.	Alt + X + S
	Cycle Swap	Rotate positions of selected objects to explore alternate layouts instantly.	Alt + X + Y

Insert Symbols

Icon	Function	Description	Shortcut
	Insert Symbols	Open a curated gallery of commonly used finance symbols for one-click insertion.	Alt + X + Y + G

Sheet Tools

Icon	Function	Description	Shortcut
	Sheet Select	Launch the advanced sheet selector to jump instantly to any tab in the workbook.	Alt + X + X
	Deep Search	Search across sheets, formulas, comments, and metadata to locate anything in seconds.	Alt + X + Q
	Visual Check	Run a comprehensive visual review to uncover inconsistent formatting and layout issues.	Alt + X + /
	Clean File	Remove unused styles, delete blank rows or columns, and optimize workbook size automatically.	Alt + X + K

Library

Icon	Function	Description	Shortcut
	Library Assets	Open the Pragmatics function library with prebuilt formulas, templates, and reusable components.	—

Charting

Format Tools

Icon	Function	Description	Shortcut
	Stack Sort	Resequence stacked series by value to improve readability and storytelling.	Alt + X + S
	Maximize Plot	Expand the chart plot area by trimming excess padding for data-first visuals.	Alt + X + M
	Center Pie	Center and resize pie charts for balanced composition and maximum impact.	Alt + X + Y + I
	Y-Min Zero	Reset the primary Y-axis minimum to zero to maintain honest comparisons.	Alt + X + Y
	Hide Y-Axis	Toggle the Y-axis to declutter visuals when labels are redundant.	Alt + X + H

Label Tools

Icon	Function	Description	Shortcut
	Keyboard Control	Enable keyboard-based positioning and formatting for chart labels.	Alt + X + K
	Reset Labels	Return all labels to their default placement and styling in a single step.	Alt + X + R
	Key Points	Automatically highlight maximums, minimums, and notable inflections on charts.	Alt + X + P
	Superscript	Format selected chart label text with superscripts for footnotes or equations.	Alt + X + S

Insert Metrics

Icon	Function	Description	Shortcut
	Arrow CAGR	Insert an arrow annotation visualizing CAGR between two points.	Alt + X + A
	Elbow CAGR	Insert an elbow-style CAGR callout with professional connectors.	Alt + X + E
	Add Stacked Totals	Place total labels atop stacked columns or bars for instant comprehension.	Alt + X + S
	Add Stat Line	Add trend or statistical lines (median, average) to enrich storytelling.	Alt + X + L
	Add Metric Bubbles	Overlay bubbles to display a secondary metric like margins or growth rates.	Alt + X + B

Duplicate & Offset

Icon	Function	Description	Shortcut
	Copy to Sheets	Duplicate the selected chart across multiple worksheets while preserving links.	Alt + X + S
	Copy via Offset	Duplicate charts by offsetting them into adjacent rows and columns.	Alt + X + R

Common Charts

Icon	Function	Description	Shortcut
	Stacked Waterfall	Insert a stacked waterfall chart to show component contributions within each step.	—
	Marimekko	Insert a Marimekko (Mekko) chart for visualizing relative share and segmentation.	—
	Gantt	Create a Gantt-style chart to plot timelines and project milestones.	—
	Bubble	Insert a bubble chart to compare series with an additional size-based metric.	—

File

Versioning & Export

Icon	Function	Description	Shortcut
	Version Up	Increment the file name version and save a new copy to maintain a clear audit trail.	Alt + X + [
	Save as PDF	Export the workbook or selected sheets to PDF with polished print settings.	Alt + X + ]
	Export Sheet	Export the active worksheet to CSV, PDF, or a new workbook without manual setup.	Alt + X + \

File Utilities

Icon	Function	Description	Shortcut
	Show in Explorer	Open Windows Explorer with the current workbook highlighted for quick access.	—
	Copy File Path	Copy the full workbook path to the clipboard for sharing or documentation.	—
	Hide Page Breaks	Remove dotted page break indicators from normal view throughout the workbook.	—

Settings

Icon	Function	Description	Shortcut
	Settings	Open Pragmatics settings to adjust defaults, shortcuts, and personalization.	Alt + X + Y + W