Open App Workspace
📚 Definitive Spreadsheet Masterclass • 100+ Shortcuts & Formulas

Complete Excel Shortcuts & Formulas: From Small to Big

Organized systematically from everyday beginner keystrokes up to senior financial analyst formulas, dynamic arrays, and auditing tools. Search instantly and copy with one click.

Beginner

Level 1: Small / Basic Essentials

The fundamental keyboard shortcuts every computer user and spreadsheet beginner must master.

18 Shortcuts
Ctrl+C
Copy
Copy selected cells, ranges, or text to system clipboard.
Ctrl+V
Paste
Paste copied clipboard contents into active cell or range.
Ctrl+X
Cut
Cut selected cells to move them elsewhere.
Ctrl+Z
Undo
Reverse the most recent action or formula entry.
Ctrl+Y
Redo
Redo the most recent undone action.
Ctrl+S
Save Workbook
Save changes to current workbook file.
Ctrl+A
Select All
Select the entire active worksheet or contiguous data table.
Ctrl+F
Find
Open Find dialog box to locate text or numbers.
Ctrl+H
Find & Replace
Open Replace dialog box to substitute characters across sheet.
Ctrl+P
Print
Open Print preview dialog to configure page layout.
Ctrl+B
Bold Text
Toggle bold formatting on selected cells.
Ctrl+I
Italic Text
Toggle italic styling on selected cells.
Ctrl+U
Underline
Toggle single underline formatting on cell text.
Ctrl+N
New Workbook
Create a brand new blank Excel workbook.
Ctrl+O
Open Workbook
Open an existing spreadsheet from your computer.
Ctrl+W
Close Window
Close active workbook window without exiting Excel.
F12
Save As
Open Save As dialog box to save file with new name or format.
Delete
Clear Contents
Delete cell values and formulas while preserving formatting.
Beginner → Intermediate

Level 2: Grid Navigation & Fast Selection

Jump across thousands of rows in milliseconds and select large datasets without tedious mouse dragging.

11 Shortcuts
Ctrl+Arrow Keys
Jump to Edge
Jump to the very edge of current data region in that direction.
Ctrl+Shift+Arrow
Select to Edge
Extend selection to the very last populated cell in that direction.
Ctrl+Home
Jump to A1
Instantly move cursor to Cell A1 (top-left of sheet).
Ctrl+End
Jump to Last Cell
Jump to bottom-right active cell in the used worksheet area.
Page Down / Up
Screen Scroll
Move one full screen view down or up within worksheet.
Alt+Page Down / Up
Horizontal Scroll
Move one full screen view to the right or left.
Ctrl+Page Down / Up
Switch Sheets
Cycle to next or previous worksheet tab in workbook.
Ctrl+Space
Select Column
Select entire column corresponding to active cell.
Shift+Space
Select Row
Select entire row corresponding to active cell.
Shift+Backspace
Collapse Selection
Collapse a large multi-cell selection down to active cell.
Ctrl+. (Period)
Cycle Corners
Move active cell clockwise to next corner of selected range.
Intermediate

Level 3: Cell Data Entry & Rapid Editing

Input data faster, replicate values down columns, and stamp current timestamps with single keypresses.

11 Shortcuts
F2
Edit In-Cell
Edit active cell directly with insertion cursor at text end.
Ctrl+Enter
Fill Selection
Fill entire selected range simultaneously with typed input.
Ctrl+D
Fill Down
Copy contents and formula from cell directly above.
Ctrl+R
Fill Right
Copy contents and formula from cell directly to the left.
Ctrl+; (Semicolon)
Insert Current Date
Insert static current date (e.g. 2026-10-14) as frozen value.
Ctrl+Shift+:
Insert Current Time
Insert static current timestamp as frozen value.
Alt+Enter
In-Cell Line Break
Insert a carriage return inside cell for multiline text.
Ctrl+E
Flash Fill
Auto-detect text patterns and split or extract values down column.
Alt+Down Arrow
Value Dropdown
Display autocomplete dropdown list of unique values in column.
Ctrl+' (Apostrophe)
Exact Formula Copy
Copy exact formula from cell above without shifting relative refs.
Esc
Cancel Edit
Cancel cell entry or formula change and restore original value.
Intermediate

Level 4: Number & Date Formatting Shortcuts

Format numbers into currencies, percentages, dates, and borders without opening the format ribbon.

11 Shortcuts
Ctrl+1
Format Cells Dialog
Open full Format Cells dialog box with all tab options.
Ctrl+Shift+$
Currency Format
Apply Currency formatting with dollar sign and 2 decimals.
Ctrl+Shift+%
Percentage Format
Apply Percentage format with zero decimal places (e.g. 15%).
Ctrl+Shift+!
Number Format
Apply Standard Number format with comma and 2 decimals.
Ctrl+Shift+#
Date Format
Apply Day-Month-Year date format (e.g. 14-Oct-26).
Ctrl+Shift+@
Time Format
Apply 12-hour Time format with AM/PM indicator.
Ctrl+Shift+^
Scientific Format
Apply exponential scientific notation (e.g. 1.25E+04).
Ctrl+Shift+~
General Format
Reset cell formatting back to unformatted General state.
Ctrl+Shift+&
Add Outline Border
Apply thin outer perimeter border around selected range.
Ctrl+Shift+_
Remove Borders
Remove all border lines from selected cells.
Ctrl+5
Strikethrough
Toggle strikethrough line across selected text or values.
Intermediate → Advanced

Level 5: Essential Formulas & Math

Build, audit, and evaluate formulas at lightning speed. Master cell locking ($) and formula toggling.

9 Shortcuts
Alt+=
Instant AutoSum
Automatically insert =SUM() formula detecting numbers above.
F4
Cycle Reference ($)
Toggle reference locks: A1 → $A$1 → A$1 → $A1 in formula.
Shift+F3
Insert Function
Open function catalog dialog to search formulas and syntax.
Ctrl+~ (Tilde)
Show Formulas
Toggle sheet view between calculated values and formula syntax.
F9
Calculate Workbooks
Force calculation of all formulas across all open workbooks.
Shift+F9
Calculate Sheet
Calculate formulas on active worksheet only.
Highlight+F9
Evaluate Fragment
Highlight part of formula in formula bar and press F9 to evaluate.
Ctrl+F3
Name Manager
Open Name Manager dialog box to create or edit named ranges.
F3
Paste Name
Paste existing Named Range into formula while editing.
Intermediate → Advanced

Level 6: Rows, Columns & Structured Tables

Manipulate table grids, insert or delete records, hide rows, and convert plain ranges into structured Excel Tables.

11 Shortcuts
Ctrl+T
Create Excel Table
Convert range into structured table with banded rows and filters.
Ctrl+Shift++
Insert Rows/Cols
Insert blank cells, rows, or columns at active selection.
Ctrl+- (Minus)
Delete Rows/Cols
Delete selected cells, rows, or columns immediately.
Ctrl+9
Hide Rows
Hide selected rows from view without deleting data.
Ctrl+0 (Zero)
Hide Columns
Hide selected columns from view without deleting data.
Ctrl+Shift+(
Unhide Rows
Unhide any hidden rows within selected range.
Ctrl+Shift+)
Unhide Columns
Unhide any hidden columns within selected range.
Shift+Alt+Right
Group Rows/Cols
Group selected rows or columns into an expandable outline tree.
Shift+Alt+Left
Ungroup Outline
Ungroup selected rows or columns.
Alt+H+O+I
Auto-Fit Columns
Automatically adjust column width to fit longest cell content.
Alt+H+O+A
Auto-Fit Rows
Automatically adjust row height to fit multiline content.
Advanced (Big / Power User)

Level 7: Big / Auditing, Dynamic Arrays & Power User

High-leverage analytical shortcuts for tracing formula dependencies, filtering visible data, and debugging models.

13 Shortcuts
Ctrl+Shift+L
Toggle AutoFilter
Turn filter dropdown arrows on or off on header row.
Alt+Down Arrow
Open Filter Menu
Open filter dropdown menu when cursor is on header cell.
F5 → Alt+S
Go To Special
Select only blank cells, formulas, constants, or visible rows.
Alt+; (Semicolon)
Select Visible Cells
Select visible cells only, ignoring hidden or collapsed rows.
Ctrl+[
Trace Precedents
Jump cursor directly to cells that feed into the active formula.
Ctrl+]
Trace Dependents
Jump cursor directly to cells that consume the active formula.
Ctrl+\
Row Differences
Select cells in a row that differ from the active comparison cell.
Ctrl+Shift+|
Column Differences
Select cells in a column that differ from active cell.
Alt+F1
Instant Chart
Generate an automatic embedded column chart from active data.
F11
Chart Sheet
Create a full-screen chart on a brand new dedicated Chart tab.
Alt+F11
VBA Editor
Open Visual Basic for Applications (VBA) macro editor window.
Alt+F8
Macro Dialog
Open Macro execution and management dialog box.
Ctrl+Shift+Enter
CSE Array Formula
Commit legacy multi-cell array formula enclosed in curly braces.
Dynamic & Modern Formulas

Top Modern Excel Formulas (Beyond VLOOKUP)

The most powerful built-in Excel functions for data transformation, dynamic arrays, and error prevention.

12 Essential Formulas
Lookup & Reference

XLOOKUP (Modern VLOOKUP Replacement)

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode])

The modern gold standard. Searches left, right, top, or bottom. No column index numbers needed. Built-in error handling without wrapping in IFERROR.

Live Example: =XLOOKUP("CUST-104", A2:A500, D2:D500, "Not Found", 0)
Lookup & Reference

INDEX & MATCH (Classic Dynamic Lookup)

=INDEX(array, MATCH(lookup_value, lookup_array, 0))

The classic, bulletproof two-way lookup formula. Immune to inserted/deleted columns and works across all legacy Excel versions (2003+).

Live Example: =INDEX(D2:D500, MATCH(F2, A2:A500, 0))
Dynamic Array

FILTER (Dynamic Array Extraction)

=FILTER(array, include_criteria, [if_empty])

Extracts all rows or columns that match specific criteria into a spilling dynamic array without modifying the source table.

Live Example: =FILTER(A2:E100, (D2:D100="Approved") * (E2:E100>5000), "No Records")
Dynamic Array

UNIQUE (Formulaic Deduplication)

=UNIQUE(array, [by_col], [exactly_once])

Extracts distinct values from a column or range. Eliminates duplicates dynamically; updates automatically when source data changes.

Live Example: =UNIQUE(B2:B250)
Dynamic Array

SORT (Dynamic Order Array)

=SORT(array, [sort_index], [sort_order])

Sorts a range by specified column index (1 for ascending, -1 for descending) without manually clicking Sort buttons.

Live Example: =SORT(A2:D50, 3, -1)
Math & Aggregation

SUMIFS (Multi-Condition Summation)

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Calculates the sum of cells matching multiple criteria across different columns simultaneously.

Live Example: =SUMIFS(E2:E100, B2:B100, "North America", D2:D100, ">2026-01-01")
Statistical

COUNTIFS (Multi-Condition Count)

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Counts the number of rows matching one or more specific criteria.

Live Example: =COUNTIFS(B2:B100, "Active", C2:C100, "<=0")
Performance

LET (Formula Variable Assignment)

=LET(name1, value1, name2, value2, calculation)

Assigns names to calculation results inside a formula. Improves readability and speeds up complex calculations by calculating repeated parts once.

Live Example: =LET(gross, C2*D2, tax, gross*0.085, gross - tax)
Text Manipulation

TEXTJOIN (Concatenation with Delimiter)

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

Combines text from multiple ranges with a specified delimiter (e.g. comma, semicolon, space), optionally ignoring blank cells.

Live Example: =TEXTJOIN(", ", TRUE, A2:D2)
Data Hygiene

TRIM & CLEAN (Whitespace & Non-Printable Purge)

=TRIM(CLEAN(text))

Essential formula duo: CLEAN removes unprintable ASCII control characters (0-31), while TRIM strips leading, trailing, and double spaces.

Live Example: =TRIM(CLEAN(A2))
Logical & Auditing

IFERROR (Error Protection)

=IFERROR(formula, fallback_value)

Evaluates formula and returns fallback value if it evaluates to #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

Live Example: =IFERROR(VLOOKUP(A2, D:E, 2, FALSE), "Missing Record")
Formatting

TEXT (Date & Number String Conversion)

=TEXT(value, "YYYY-MM-DD")

Converts numeric dates or numbers into formatted text strings with exact formatting mask.

Live Example: =TEXT(A2, "YYYY-MM-DD")

Have messy spreadsheets that formulas can't fix?

Formulas won't easily fix non-breaking spaces, corrupted dates, or multi-column duplicate leads. Let SheetFix AI clean your workbook in seconds — 100% locally in your browser.

Clean Your Spreadsheet Free →
Copied to clipboard!