consumerguidepro-excel-keyboard-shortcuts

Accept Function Autocomplete (Tab)

Accept Function Autocomplete (Tab) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Add an Outline Border Quickly (Ctrl+Shift+&)

Add an Outline Border Quickly (Ctrl+Shift+&) for Windows and Mac: keys, steps, and tips to work faster with formulas.

AutoSum in One Keystroke (Alt+= / Cmd+Shift+T)

AutoSum in One Keystroke (Alt+= / Cmd+Shift+T) for Windows and Mac: keys, steps, and tips to work faster with formulas.

AutoSum in One Keystroke (Alt+= / Cmd+Shift+T): Advanced Workflow Variant

AutoSum in One Keystroke (Alt+= / Cmd+Shift+T): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Calculation and Performance: Shortcuts and Habits for Large Excel Models

Keep large Excel workbooks fast with calculation shortcuts and performance habits: recalc, manual calc, reduce volatility, and stabilize outputs.

Check Spelling (F7)

Check Spelling (F7) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Complete an Entry and Stay Put (Ctrl+Enter)

Complete an Entry and Stay Put (Ctrl+Enter) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Copy Formula from the Cell Above (Ctrl+')

Copy Formula from the Cell Above (Ctrl+') for Windows and Mac: keys, steps, and tips to work faster with formulas.

Copy Value from the Cell Above

Copy Value from the Cell Above for Windows and Mac: keys, steps, and tips to work faster with formulas.

Core Workbook Shortcuts (New/Open/Save/Print)

Core Workbook Shortcuts (New/Open/Save/Print) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Create a Chart Fast (Alt+F1 / F11)

Create a Chart Fast (Alt+F1 / F11) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Define Names from Labels (Ctrl+Shift+F3)

Define Names from Labels (Ctrl+Shift+F3) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Define Names from Labels (Ctrl+Shift+F3): Advanced Workflow Variant

Define Names from Labels (Ctrl+Shift+F3): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Define Names from Labels (Ctrl+Shift+F3): Advanced Workflow Variant

Define Names from Labels (Ctrl+Shift+F3): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Delete Rows or Columns (Ctrl+- / Cmd+-)

Delete Rows or Columns (Ctrl+- / Cmd+-) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Edit the Active Cell Without the Mouse (F2 / Ctrl+U)

Edit the Active Cell Without the Mouse (F2 / Ctrl+U) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Edit the Active Cell Without the Mouse (F2 / Ctrl+U): Advanced Workflow Variant

Edit the Active Cell Without the Mouse (F2 / Ctrl+U): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with form...

Excel Keyboard Shortcuts Starter Kit: Windows vs Mac for Daily Speed

A practical starter kit of Excel shortcuts for Windows and Mac to speed up editing, navigation, and formulas in minutes.

Expand or Collapse the Formula Bar (Ctrl+Shift+U)

Expand or Collapse the Formula Bar (Ctrl+Shift+U) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Expand or Collapse the Formula Bar (Ctrl+Shift+U): Advanced Workflow Variant

Expand or Collapse the Formula Bar (Ctrl+Shift+U): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Expand or Collapse the Ribbon

Expand or Collapse the Ribbon for Windows and Mac: keys, steps, and tips to work faster with formulas.

Extend Selection to the Edge (Ctrl+Shift+Arrow)

Extend Selection to the Edge (Ctrl+Shift+Arrow) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Fast Data Entry Shortcuts: Fill, Repeat, and Build Tables Quickly

Enter data faster in Excel using keyboard-first techniques: fill down/right, repeat actions, multi-cell entry, and clean inputs.

Fill Down Without Dragging (Ctrl+D / Cmd+D)

Fill Down Without Dragging (Ctrl+D / Cmd+D) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Fill Down Without Dragging (Ctrl+D / Cmd+D): Advanced Workflow Variant

Fill Down Without Dragging (Ctrl+D / Cmd+D): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Fill Down Without Dragging (Ctrl+D / Cmd+D): Advanced Workflow Variant

Fill Down Without Dragging (Ctrl+D / Cmd+D): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Fill Right Without Dragging (Ctrl+R / Cmd+R)

Fill Right Without Dragging (Ctrl+R / Cmd+R) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Fill Right Without Dragging (Ctrl+R / Cmd+R): Advanced Workflow Variant

Fill Right Without Dragging (Ctrl+R / Cmd+R): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Fill Right Without Dragging (Ctrl+R / Cmd+R): Advanced Workflow Variant

Fill Right Without Dragging (Ctrl+R / Cmd+R): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Find Fast in Excel (Ctrl+F / Cmd+F)

Find Fast in Excel (Ctrl+F / Cmd+F) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Find Fast in Excel (Ctrl+F / Cmd+F): Advanced Workflow Variant

Find Fast in Excel (Ctrl+F / Cmd+F): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Find Fast in Excel (Ctrl+F / Cmd+F): Advanced Workflow Variant

Find Fast in Excel (Ctrl+F / Cmd+F): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Find Next/Previous Matches (Shift+F4 / Cmd+G)

Find Next/Previous Matches (Shift+F4 / Cmd+G) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Find Next/Previous Matches (Shift+F4 / Cmd+G): Advanced Workflow Variant

Find Next/Previous Matches (Shift+F4 / Cmd+G): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Find Next/Previous Matches (Shift+F4 / Cmd+G): Advanced Workflow Variant

Find Next/Previous Matches (Shift+F4 / Cmd+G): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Flash Fill (Ctrl+E / Ctrl+E)

Flash Fill (Ctrl+E / Ctrl+E) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Formatting Shortcuts for Analysts: Number Formats, Borders, and Readability

Make Excel models easier to read and audit with keyboard-first formatting: number formats, alignment, borders, and consistency rules.

Formula Auditing and Troubleshooting: Keyboard-First Checks That Prevent Mistakes

Audit Excel formulas faster with keyboard-first techniques: show formulas, spot inconsistencies, isolate errors, and validate logic reliably.

Formula Editing Shortcuts: Absolute References, AutoSum, and Faster Function Writing

Speed up formulas in Excel with shortcuts for absolute references, AutoSum, insert function, show formulas, and quick recalculation.

Go to First/Last Used Cell (Ctrl+Home / Ctrl+End)

Go to First/Last Used Cell (Ctrl+Home / Ctrl+End) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Group and Ungroup Rows/Columns

Group and Ungroup Rows/Columns for Windows and Mac: keys, steps, and tips to work faster with formulas.

Hide and Unhide Rows/Columns (Ctrl+9/0)

Hide and Unhide Rows/Columns (Ctrl+9/0) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Insert Argument Names in a Function (Ctrl+Shift+A)

Insert Argument Names in a Function (Ctrl+Shift+A) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Insert Argument Names in a Function (Ctrl+Shift+A): Advanced Workflow Variant

Insert Argument Names in a Function (Ctrl+Shift+A): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Insert Notes and Threaded Comments

Insert Notes and Threaded Comments for Windows and Mac: keys, steps, and tips to work faster with formulas.

Insert Rows or Columns (Ctrl+Shift+Plus)

Insert Rows or Columns (Ctrl+Shift+Plus) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Insert Today’s Date (Ctrl+;)

Insert Today’s Date (Ctrl+;) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Insert a Function Faster (Shift+F3)

Insert a Function Faster (Shift+F3) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Insert a Function Faster (Shift+F3): Advanced Workflow Variant

Insert a Function Faster (Shift+F3): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Insert a Hyperlink (Ctrl+K / Cmd+K)

Insert a Hyperlink (Ctrl+K / Cmd+K) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Insert a Line Break in a Cell

Insert a Line Break in a Cell for Windows and Mac: keys, steps, and tips to work faster with formulas.

Insert a New Worksheet (Shift+F11)

Insert a New Worksheet (Shift+F11) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Insert the Current Time

Insert the Current Time for Windows and Mac: keys, steps, and tips to work faster with formulas.

Jump to a Cell or Named Range (Ctrl+G)

Jump to a Cell or Named Range (Ctrl+G) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Jump to the Edge of a Data Region (Ctrl+Arrow / Cmd+Arrow)

Jump to the Edge of a Data Region (Ctrl+Arrow / Cmd+Arrow) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Move Between Worksheets (Ctrl+PgUp/PgDn)

Move Between Worksheets (Ctrl+PgUp/PgDn) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Move to the Beginning of a Row (Home / Fn+Left)

Move to the Beginning of a Row (Home / Fn+Left) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Named Ranges and the Name Manager: Build Faster, Cleaner Formulas

Use named ranges to make Excel formulas readable and scalable. Learn how to name inputs, manage names, and use them in formulas.

Navigation and Selection Shortcuts: Move and Select Like a Power User

Master Excel navigation and selection on Windows and Mac: jump by data blocks, select ranges fast, and move across sheets efficiently.

Open Format Cells Instantly (Ctrl+1 / Cmd+1)

Open Format Cells Instantly (Ctrl+1 / Cmd+1) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Format Cells Instantly (Ctrl+1 / Cmd+1): Advanced Workflow Variant

Open Format Cells Instantly (Ctrl+1 / Cmd+1): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Format Cells Instantly (Ctrl+1 / Cmd+1): Advanced Workflow Variant

Open Format Cells Instantly (Ctrl+1 / Cmd+1): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Function Arguments While Editing (Ctrl+A)

Open Function Arguments While Editing (Ctrl+A) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Function Arguments While Editing (Ctrl+A): Advanced Workflow Variant

Open Function Arguments While Editing (Ctrl+A): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Help Quickly

Open Help Quickly for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Macros and the VBA Editor

Open Macros and the VBA Editor for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Name Manager Fast (Ctrl+F3)

Open Name Manager Fast (Ctrl+F3) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Name Manager Fast (Ctrl+F3): Advanced Workflow Variant

Open Name Manager Fast (Ctrl+F3): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Options/Preferences

Open Options/Preferences for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Paste Special (Ctrl+Alt+V / Cmd+Ctrl+V)

Open Paste Special (Ctrl+Alt+V / Cmd+Ctrl+V) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Paste Special (Ctrl+Alt+V / Cmd+Ctrl+V): Advanced Workflow Variant

Open Paste Special (Ctrl+Alt+V / Cmd+Ctrl+V): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open Paste Special (Ctrl+Alt+V / Cmd+Ctrl+V): Advanced Workflow Variant

Open Paste Special (Ctrl+Alt+V / Cmd+Ctrl+V): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open a Filter Drop-Down (Alt+Down / Option+Down)

Open a Filter Drop-Down (Alt+Down / Option+Down) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Open the Context Menu (Shift+F10)

Open the Context Menu (Shift+F10) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Paste Special and Cleanup Shortcuts: Values, Formats, and Safer Copying

Learn Excel paste workflows that prevent broken formulas: paste values, paste formats, transpose, and clean data faster on Windows and Mac.

Paste Values Fast (Ctrl+Shift+V / Cmd+Shift+V)

Paste Values Fast (Ctrl+Shift+V / Cmd+Shift+V) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Paste Values Fast (Ctrl+Shift+V / Cmd+Shift+V): Advanced Workflow Variant

Paste Values Fast (Ctrl+Shift+V / Cmd+Shift+V): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Paste Values Fast (Ctrl+Shift+V / Cmd+Shift+V): Advanced Workflow Variant

Paste Values Fast (Ctrl+Shift+V / Cmd+Shift+V): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Paste a Defined Name into a Formula (F3)

Paste a Defined Name into a Formula (F3) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Paste a Defined Name into a Formula (F3): Advanced Workflow Variant

Paste a Defined Name into a Formula (F3): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

PivotTable Productivity: Build, Refresh, and Drill Down Faster

Create and use PivotTables faster in Excel on Windows and Mac: build from Tables, refresh quickly, drill down, and keep pivots stable.

Recalculate Formulas on Demand (F9 / Shift+F9)

Recalculate Formulas on Demand (F9 / Shift+F9) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Recalculate Formulas on Demand (F9 / Shift+F9): Advanced Workflow Variant

Recalculate Formulas on Demand (F9 / Shift+F9): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Remove Borders Fast (Ctrl+Shift+_)

Remove Borders Fast (Ctrl+Shift+_) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Replace at Scale (Ctrl+H)

Replace at Scale (Ctrl+H) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Replace at Scale (Ctrl+H): Advanced Workflow Variant

Replace at Scale (Ctrl+H): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Replace at Scale (Ctrl+H): Advanced Workflow Variant

Replace at Scale (Ctrl+H): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Select All Dependents (Ctrl+Shift+})

Select All Dependents (Ctrl+Shift+}) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Select All Precedents (Ctrl+Shift+{)

Select All Precedents (Ctrl+Shift+{) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Select Direct Dependents (Ctrl+])

Select Direct Dependents (Ctrl+]) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Select Direct Precedents (Ctrl+[)

Select Direct Precedents (Ctrl+[) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Select Only the Active Cell

Select Only the Active Cell for Windows and Mac: keys, steps, and tips to work faster with formulas.

Select Visible Cells Only (Alt+; / Cmd+Shift+Z)

Select Visible Cells Only (Alt+; / Cmd+Shift+Z) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Select an Entire Column (Ctrl+Space)

Select an Entire Column (Ctrl+Space) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Select an Entire Row (Shift+Space)

Select an Entire Row (Shift+Space) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Select the Current Region (Ctrl+Shift+*)

Select the Current Region (Ctrl+Shift+*) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Show Formulas Instead of Results (Ctrl+`)

Show Formulas Instead of Results (Ctrl+`) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Show Formulas Instead of Results (Ctrl+`): Advanced Workflow Variant

Show Formulas Instead of Results (Ctrl+`): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Show the Active Cell on Screen

Show the Active Cell on Screen for Windows and Mac: keys, steps, and tips to work faster with formulas.

Switch Between Open Workbooks

Switch Between Open Workbooks for Windows and Mac: keys, steps, and tips to work faster with formulas.

Switch Focus Between Worksheet and Panes (F6)

Switch Focus Between Worksheet and Panes (F6) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Toggle Absolute References Fast (F4 / Cmd+T)

Toggle Absolute References Fast (F4 / Cmd+T) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Toggle Absolute References Fast (F4 / Cmd+T): Advanced Workflow Variant

Toggle Absolute References Fast (F4 / Cmd+T): Advanced Workflow Variant for Windows and Mac: keys, steps, and tips to work faster with formulas.

Toggle Extend Selection Mode (F8)

Toggle Extend Selection Mode (F8) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Toggle Filters Quickly

Toggle Filters Quickly for Windows and Mac: keys, steps, and tips to work faster with formulas.

Toggle Full Screen

Toggle Full Screen for Windows and Mac: keys, steps, and tips to work faster with formulas.

Turn a Range into a Table (Ctrl+T / Cmd+T)

Turn a Range into a Table (Ctrl+T / Cmd+T) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Undo, Redo, and Repeat

Undo, Redo, and Repeat for Windows and Mac: keys, steps, and tips to work faster with formulas.

Use Number Format Shortcuts (Ctrl+Shift + symbol)

Use Number Format Shortcuts (Ctrl+Shift + symbol) for Windows and Mac: keys, steps, and tips to work faster with formulas.

Working with Excel Tables: Shortcuts for Filters, Structured References, and Totals

Use Excel Tables to make formulas reliable. Learn keyboard-first filtering, sorting, total rows, and structured reference workflows.

Zoom In and Out

Zoom In and Out for Windows and Mac: keys, steps, and tips to work faster with formulas.