Excel Shortcuts
Searchable reference of essential Excel keyboard shortcuts.
Ad
56 shortcuts
General(14)
Ctrl+CCopy
Ctrl+XCut
Ctrl+VPaste
Ctrl+ZUndo
Ctrl+YRedo
Ctrl+SSave
Ctrl+PPrint
Ctrl+WClose workbook
Ctrl+NNew workbook
Ctrl+OOpen workbook
Ctrl+FFind
Ctrl+HFind & Replace
F12Save As
Alt+F4Close Excel
Navigation(9)
Ctrl+HomeGo to cell A1
Ctrl+EndGo to last used cell
Ctrl+ArrowJump to edge of data region
Ctrl+GGo To dialog
Ctrl+Page DownNext sheet
Ctrl+Page UpPrevious sheet
TabMove one cell right
EnterMove one cell down
F5Go To (Name Box)
Selection(7)
Ctrl+ASelect all cells
Ctrl+Shift+EndExtend selection to last cell
Ctrl+Shift+HomeExtend selection to A1
Shift+ArrowExtend selection by one cell
Ctrl+Shift+ArrowExtend selection to edge of data
Ctrl+SpaceSelect entire column
Shift+SpaceSelect entire row
Formatting(9)
Ctrl+BBold
Ctrl+IItalic
Ctrl+UUnderline
Ctrl+1Format Cells dialog
Ctrl+Shift+$Apply currency format
Ctrl+Shift+%Apply percentage format
Ctrl+Shift+#Apply date format
Ctrl+Shift+~Apply general format
Alt+H+BAdd border
Data(9)
Ctrl+TCreate table
Ctrl+Shift+LToggle AutoFilter
Alt+D+SSort dialog
Ctrl+DFill down
Ctrl+RFill right
Ctrl+;Insert current date
Ctrl+Shift+;Insert current time
Ctrl+-Delete cells / rows / columns
Ctrl+Shift++Insert cells / rows / columns
Formula(8)
F2Edit active cell
F4Toggle absolute/relative reference ($)
Alt+=AutoSum
Ctrl+`Toggle formula view
Ctrl+Shift+EnterEnter array formula
Shift+F3Insert Function dialog
F9Calculate all sheets
Ctrl+[Select precedent cells
Ad
Excel Shortcuts: A comprehensive, searchable reference of 57 essential Excel keyboard shortcuts organized into 6 categories — General, Navigation, Selection, Formatting, Data, and Formula. Search by key combination or description to quickly find the shortcut you need.