Skip to content

Excel Keyboard Shortcuts Cheatsheet — Printable PDF Reference

DodaTech Updated 2026-06-20 6 min read

In this tutorial, you'll learn about Excel Keyboard Shortcuts Cheatsheet. We cover key concepts, practical examples, and best practices to help you understand and apply this topic effectively.

📄 Printable PDF: Use your browser's Print (Ctrl+P / Cmd+P) → "Save as PDF" to get a printer-friendly PDF of this Excel shortcut cheatsheet.

Complete Excel keyboard shortcuts for faster spreadsheets, formulas, data analysis, PivotTables, charts, and workbook management. Windows shortcuts listed.

Shortcut What it does
Arrow keys Move one cell
Ctrl+Arrow Jump to edge of data region
Home Move to start of row
Ctrl+Home Go to cell A1
Ctrl+End Go to last used cell
Page Up / Down Move one screen up / down
Alt+Page Down / Up Move one screen right / left
Ctrl+G or F5 Go to dialog
Shift+Arrow Extend selection by one cell
Ctrl+Shift+Arrow Extend to edge of data region
Shift+Space Select entire row
Ctrl+Space Select entire column
Ctrl+A Select all (entire sheet)
Ctrl+Shift+End Extend to last used cell
Ctrl+Shift+Home Extend to A1
Shift+Page Down / Up Extend selection one screen
Ctrl+Shift+8 (*) Select current region

Editing & Formatting

Shortcut What it does
F2 Edit active cell
Esc Cancel editing
Enter Confirm edit and move down
Ctrl+Enter Fill selected cells with current entry
Tab Confirm edit and move right
Shift+Enter Confirm edit and move up
Shift+Tab Confirm edit and move left
Ctrl+D Fill down (copy from cell above)
Ctrl+R Fill right (copy from cell left)
Ctrl+Z Undo
Ctrl+Y Redo
Ctrl+C / Ctrl+X / Ctrl+V Copy / Cut / Paste
Ctrl+Alt+V Paste Special dialog
Ctrl+B Bold
Ctrl+I Italic
Ctrl+U Underline
Ctrl+1 Format Cells dialog
Ctrl+Shift+~ General number format
Ctrl+Shift+$ Currency format
Ctrl+Shift+% Percentage format
Ctrl+Shift+# Date format
Ctrl+Shift+@ Time format
Ctrl+Shift+! Number format (2 decimals)
Ctrl+Shift+& Apply outline border
Ctrl+Shift+_ Remove outline border
Alt+H+0 Increase decimal
Alt+H+9 Decrease decimal

Formulas & Functions

Shortcut What it does
= Start a formula
Alt+= AutoSum (SUM)
Shift+F3 Insert Function dialog
Ctrl+Shift+A Insert function arguments
F4 Toggle absolute / relative reference
Ctrl+ ` (backtick) Show formulas instead of values
F9 Calculate all worksheets
Shift+F9 Calculate active sheet
Ctrl+Alt+F9 Force full calculation
Ctrl+Enter Enter formula in multiple cells
Ctrl+Shift+Enter Array formula (legacy)
Alt+↓ AutoComplete list (formula)
Ctrl+Shift+U Expand / collapse formula bar
F2 then F9 Evaluate part of formula (select then F9)

Data Manipulation

Shortcut What it does
Alt+D+T Sort dialog
Alt+A+S+S Sort A to Z
Alt+A+S+O Sort Z to A
Alt+A+T Filter (toggle auto-filter)
Alt+↓ Open filter menu (in header)
Ctrl+Shift+L Toggle filter
Alt+; Select visible cells (goto special)
Ctrl+Shift+: Insert current time
Ctrl+; Insert current date
Ctrl+\ Select row differences
Ctrl+Shift+\ Select column differences
Ctrl+Shift+{ Select direct precedents
Ctrl+Shift+} Select direct dependents
Ctrl+[ Go to precedents
Ctrl+] Go to dependents
Alt+A+E Remove duplicates
Alt+A+V+V Data Validation dialog
Alt+D+G+G Consolidate dialog
Alt+A+M Merge & Center

PivotTables & Charts

Shortcut What it does
Alt+N+V Create PivotTable
Alt+JT PivotTable Tools Analyze tab
Alt+JS PivotTable Tools Design tab
Ctrl+Shift+* Select entire PivotTable
Alt+F1 Create chart in new sheet
F11 Create chart in new sheet (sized)
Alt+N+C+O Create column chart
Alt+N+C+L Create line chart
Alt+N+C+P Create pie chart
Ctrl+Page Down / Up Next / Previous sheet

Workbook Management

Shortcut What it does
Ctrl+N New workbook
Ctrl+O Open workbook
Ctrl+S Save workbook
F12 Save As
Ctrl+P Print
Ctrl+W Close workbook
Ctrl+F4 Close workbook
Alt+F4 Exit Excel
Ctrl+F6 Next workbook window
Ctrl+Shift+F6 Previous workbook window
Ctrl+Tab Next workbook
Ctrl+Shift+Tab Previous workbook
Shift+F11 Insert new worksheet
Ctrl+Shift+F11 Insert new sheet (right-click)
Ctrl+Page Down Next sheet
Ctrl+Page Up Previous sheet
Alt+E+L Delete sheet (legacy)
Alt+E+M Move or copy sheet
F2 Rename sheet (on sheet tab)
Alt+O+H+R Rename sheet (legacy)

Cell Operations

Shortcut What it does
Delete Clear cell contents
Ctrl+- Delete cells / rows / columns
Ctrl+Shift+=(+) Insert cells / rows / columns
Ctrl++ Insert (alternative)
Alt+H+D+R Delete row
Alt+H+D+C Delete column
Alt+H+I+R Insert row
Alt+H+I+C Insert column
Ctrl+Shift++ Insert (all contexts)
Ctrl+Alt+V, V Paste Values only
Ctrl+Alt+V, T Paste Formatting only
Ctrl+Alt+V, F Paste Formula only
Ctrl+Alt+V, W Paste Column widths only
F2 Edit cell / enter formula mode
Alt+Enter Line break within a cell
Ctrl+Delete Delete text to end of line

Printing & Layout

Shortcut What it does
Ctrl+P Print dialog
Alt+P+S+P Set print area
Alt+P+S+C Clear print area
Alt+P+P Print preview
Ctrl+F2 Print preview (alternate)
Alt+P+S+O Page Setup dialog
Alt+P+M Margins tab in Page Setup
Alt+P+H Header / Footer tab
Alt+P+S Sheet tab in Page Setup
Alt+P+S+Z Zoom to selection
Ctrl+Shift+Arrow Select until blank (for print range)
How do I create a PivotTable in Excel?

Select your data range, then press Alt+N+V. Excel opens the Create PivotTable dialog — confirm the range and destination. Drag fields from the PivotTable Fields pane to Rows, Columns, Values, and Filters areas to build your report. Use Ctrl+Shift+* to select the entire PivotTable for quick formatting.

How do I quickly sum a column in Excel?

Select the cell below (or to the right of) the numbers you want to sum, then press Alt+=. Excel inserts a SUM formula automatically, guessing the range. Press Enter to confirm. For multiple columns, select an entire range and press Alt+= once — Excel fills all SUM formulas at once.

See the full Excel guide for advanced data analysis and formulas.

← Previous Figma Keyboard Shortcuts Cheatsheet — Printable PDF Reference Next → TypeScript Cheatsheet — Complete Quick Reference (2026)

Built by the developers of DodaTech

Doda Browser, DodaZIP & Durga Antivirus Pro

Home Browse Cheatsheets