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.
Font Cycle

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.
Video demonstration of Auto Color

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.
Fill Cycle

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.
Number Format

Date Format

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

Percentage Format

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

Multiple Format

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

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).
Year Cycle

Decimals

Increase Decimal

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

Decrease Decimal

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

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.
Outline Cycle

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.
Border Bottom Cycle

Alignment

Center Across Selection

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

Decrease Indent

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

Increase Indent

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

Cell Size

Height Cycle

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

Width Cycle

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

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.
Video demonstration of Super Trace Precedents

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.
Video demonstration of Super Trace Dependents

Math Operations

Divide by 1000

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

Multiply by 1000

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

Negative

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

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.
Video demonstration of Paste Exact

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.
Video demonstration of Paste Exact Transpose

Ribbon Features

Unhide All Names

Unhides all hidden named ranges in the workbook, making them visible in the name manager.
Video demonstration of Unhide All Names

Delete All Pics

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

Multi Goal Seek

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

Toggle Decimal Separator

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

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.
Font Cycle

Fill Cycle

Customize the colors and patterns used in Fill Cycle.
Fill Cycle

Cell Size

Customize the values used in Height Cycle and Width Cycle.
Cell Size

Manage Shortcuts

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