Productivity

📗Microsoft Excel Keyboard Shortcuts

30 essential shortcuts for Microsoft Excel

General

ShortcutAction
Ctrl+N/⌘NNew workbook
Ctrl+S/⌘SSave
Ctrl+Z/⌘ZUndo
Ctrl+Y/⌘YRedo/repeat

Editing

ShortcutAction
F2Edit active cell
Ctrl+;/⌘;Insert current date
Ctrl+Shift+;/⌘⇧;Insert current time
Ctrl+D/⌘DFill down
Ctrl+R/⌘RFill right
Ctrl+Shift+=/⌘⇧=Insert cells/rows/columns
Ctrl+-/⌘-Delete cells/rows/columns

Navigation

ShortcutAction
Tab/Shift+TabMove to next / previous cell
Ctrl+Home/⌘HomeGo to cell A1
Ctrl+End/⌘EndGo to last used cell
Ctrl+G/F5Go To dialog
Ctrl+Page Down/UpNext / previous worksheet
Ctrl+Arrow keysJump to edge of data region

Selection

ShortcutAction
Ctrl+SpaceSelect entire column
Shift+SpaceSelect entire row
Ctrl+Shift+EndExtend selection to last used cell

Formatting

ShortcutAction
Ctrl+B/⌘BBold
Ctrl+I/⌘IItalic
Ctrl+Shift+$/⌘⇧$Currency format
Ctrl+Shift+%/⌘⇧%Percentage format
Ctrl+Shift+#/⌘⇧#Date format
Ctrl+1/⌘1Format Cells dialog

Formulas

ShortcutAction
Alt+=/⌘⇧TAutoSum
Ctrl+` (grave)Toggle formula view
F4 (in formula)Toggle absolute/relative reference

Data

ShortcutAction
Ctrl+Shift+L/⌘⇧LToggle AutoFilter

About Microsoft Excel Shortcuts

Microsoft Excel is the industry-standard spreadsheet application for data analysis, financial modeling, reporting, and visualization. Excel supports formulas, pivot tables, charts, VBA macros, Power Query, and data validation. Its comprehensive keyboard shortcuts cover cell navigation, formula editing, formatting, data manipulation, and workbook management, enabling analysts to work at maximum efficiency.

This reference covers 30 essential Microsoft Excel keyboard shortcuts organized across 7 categories: General, Editing, Navigation, and more. Each shortcut lists both macOS and Windows/Linux key combinations where applicable, making it easy to find the right key combo regardless of your operating system.

Learning keyboard shortcuts is one of the highest-leverage investments you can make in your daily workflow. Studies show that developers and designers who rely on keyboard shortcuts are measurably faster at common tasks. Rather than memorizing every shortcut at once, focus on the ones you use most frequently and gradually expand your repertoire.

Bookmark this page for quick reference whenever you need to look up a Microsoft Excel shortcut. The categorized layout makes it easy to find shortcuts by their function, whether you need navigation, editing, or specialized commands.

Related apps