QuickCel Shortcuts
Complete reference guide for all QuickCel shortcuts and features.
Formatting
Color Cycles
Font Cycle
Ctrl
'
Tap to quickly cycle the font color of the selected cells through a palette. Default colors are Black, Blue, Green, and Gray. Colors are customizable.

Auto Color
Ctrl
Alt
A
Automatically applies color formatting to selected cells based on their content (blue for inputs, green for links and black for formulas). Colors are customizable.

Fill Cycle
Ctrl
Shift
K
Tap to quickly cycle the fill color of the selected cells through a palette: Yellow, Light Gray, Light Blue, and Cracked Gray. Colors are customizable.

Number Formatting
Number Format
Ctrl
Shift
1
Applies the industry-standard accounting format: thousands separator, negative numbers in parentheses, and zero values as a dash.

Date Format
Ctrl
Shift
3
Applies date formatting to selected cells in the format MMM-YY.

Percentage Format
Ctrl
Shift
5
Applies the industry-standard percentage formatting: negative numbers in parentheses, and zero values as a dash.

Multiple Format
Ctrl
Shift
8
Formats selected numbers to include an "x" suffix (e.g., 2.5x) and displays negative values in parentheses.

Year Cycle
Ctrl
Shift
Y
Tap to cycle the selected year cells through the standard financial modeling suffixes: A (Actual), B (Budget), and E (Estimated).

Decimals
Increase Decimal
Ctrl
Alt
.
Each tap increases the number of decimal places displayed in the selected cells.

Decrease Decimal
Ctrl
Alt
,
Each tap decreases the number of decimal places displayed in the selected cells.

Borders
Outline Cycle
Ctrl
Shift
7
Tap to cycle the border style of the selected cells through five options: Solid, Dashed, Dotted, White, and No Border.

Border Bottom Cycle
Ctrl
Shift
B
Tap to cycle the bottom border style of the selected cells through four options: Solid, Dashed, Dotted and No Border.

Alignment
Center Across Selection
Ctrl
Alt
Down
Centers the text across the selected cells.

Decrease Indent
Ctrl
Alt
Left
Each tap decreases the indent level of selected cells.

Increase Indent
Ctrl
Alt
Right
Each tap increases the indent level of selected cells.

Cell Size
Height Cycle
Ctrl
Shift
H
Cycles through different row heights for the selected rows. Values are customizable.

Width Cycle
Ctrl
Shift
W
Cycles through different column widths for the selected columns. Values are customizable.

Special Functions
Super Trace
Super Trace Precedents
Ctrl
Shift
[
Opens a dedicated navigation panel to instantly trace and drill-down through all precedents of a formula across multiple sheets and levels.

Super Trace Dependents
Ctrl
Shift
]
Opens a dedicated navigation panel to instantly trace and drill-down through all dependents of a formula across multiple sheets and levels.

Math Operations
Divide by 1000
Ctrl
Shift
D
Quickly divides the selected numeric values by 1000.

Multiply by 1000
Ctrl
Shift
M
Quickly multiplies the selected numeric values by 1000.

Negative
Ctrl
Shift
N
Quickly multiplies the selected numeric values by -1.

Paste Exact
Special Copy
Ctrl
Alt
X
Copy Formula (Absolute Reference): Copies the formula text without changing the cell references. Enabler for Paste Exact and Paste Exact Transpose.
Paste Exact
Ctrl
Alt
E
Pastes the formula text, maintaining the original cell references from the Special Copy operation (Ctrl + Alt + X). Check out our blog post for a practical example.

Paste Exact Transpose
Ctrl
Alt
T
Pastes the formula text in transposed format, maintaining the original cell references from the Special Copy operation (Ctrl + Alt + X). Check out our blog post for a practical example.

Ribbon Features
Unhide All Names
Unhides all hidden named ranges in the workbook, making them visible in the name manager.

Break Ghost Links
Breaks external links that no longer exist or are causing errors in your workbook.

Delete All Pics
Removes all pictures and images from the active worksheet.

Multi Goal Seek
Performs goal seek analysis on multiple cells simultaneously to find target values.

Toggle Decimal Separator
Switches between comma and period as decimal separator for number formatting.

Customize
Font Cycle
Customize the font colors used in Font Cycle, and assign colors for Inputs, Formulas, Internal Links, and External Links for Auto Color.

Manage Shortcuts
Enable and disable shortcuts that you don't use.


