Excel Keyboard Shortcuts
Complete keyboard shortcut reference for Excel on MacWindowsLinux.
Selection
| Action | Shortcut |
|---|---|
| Select all cells | CmdACtrlACtrlA |
| Extend selection by one cell | ShiftArrowShiftArrowShiftArrow |
| Select to beginning of row | ShiftFnLeftShiftHomeShiftHome |
| Select to cell A1 | CtrlShiftFnLeftCtrlShiftHomeCtrlShiftHome |
| Select to last used cell | CtrlShiftFnRightCtrlShiftEndCtrlShiftEnd |
| Select entire column | CtrlSpaceCtrlSpaceCtrlSpace |
| Select entire row | ShiftSpaceShiftSpaceShiftSpace |
| Select to edge of data region | CmdShiftArrowCtrlShiftArrowCtrlShiftArrow |
| Select current region | CmdShift*CtrlShift*CtrlShift* |
| Add non-adjacent cells to selection | CmdClickCtrlClickCtrlClick |
Editing
| Action | Shortcut |
|---|---|
| Cut | CmdXCtrlXCtrlX |
| Copy | CmdCCtrlCCtrlC |
| Paste | CmdVCtrlVCtrlV |
| Paste Special | CmdCtrlVCtrlAltVCtrlAltV |
| Undo | CmdZCtrlZCtrlZ |
| Redo | CmdYCtrlYCtrlY |
| Edit active cell | F2F2F2 |
| Delete cell contents | DeleteDeleteDelete |
| Find | CmdFCtrlFCtrlF |
| Find and Replace | CmdHCtrlHCtrlH |
| Fill down | CmdDCtrlDCtrlD |
| Fill right | CmdRCtrlRCtrlR |
| Insert current date | Ctrl;Ctrl;Ctrl; |
| Insert current time | Cmd;CtrlShift;CtrlShift; |
Formatting
| Action | Shortcut |
|---|---|
| Bold | CmdBCtrlBCtrlB |
| Italic | CmdICtrlICtrlI |
| Underline | CmdUCtrlUCtrlU |
| Strikethrough | CmdShiftXCtrl5Ctrl5 |
| Open Format Cells dialog | Cmd1Ctrl1Ctrl1 |
| Apply General number format | CtrlShift~CtrlShift~CtrlShift~ |
| Apply Currency format | CtrlShift$CtrlShift$CtrlShift$ |
| Apply Percentage format | CtrlShift%CtrlShift%CtrlShift% |
| Apply Date format | CtrlShift#CtrlShift#CtrlShift# |
| Apply Number format with commas | CtrlShift!CtrlShift!CtrlShift! |
| Add or remove border outline | CmdAlt0CtrlShift&CtrlShift& |
| Remove all borders | CmdAlt-CtrlShift_CtrlShift_ |
Formulas
| Action | Shortcut |
|---|---|
| Start a formula | === |
| Insert AutoSum | CmdShiftTAlt=Alt= |
| Toggle formula display | Ctrl`Ctrl`Ctrl` |
| Insert function | ShiftF3ShiftF3ShiftF3 |
| Accept formula with Enter | ReturnEnterEnter |
| Cancel formula entry | EscapeEscapeEscape |
| Toggle absolute/relative reference (F4) | F4F4F4 |
| Enter array formula | CmdShiftReturnCtrlShiftEnterCtrlShiftEnter |
| Calculate all workbooks | Cmd=F9F9 |
| Calculate active worksheet | CmdShift=ShiftF9ShiftF9 |
| Name a range | CmdF3CtrlF3CtrlF3 |
Data Management
| Action | Shortcut |
|---|---|
| Toggle AutoFilter | CmdShiftLCtrlShiftLCtrlShiftL |
| Open Sort dialog | CmdShiftRAltDSAltDS |
| Group rows or columns | CmdShiftKAltShiftRightAltShiftRight |
| Ungroup rows or columns | CmdShiftJAltShiftLeftAltShiftLeft |
| Hide selected rows | Cmd9Ctrl9Ctrl9 |
| Unhide selected rows | CmdShift9CtrlShift9CtrlShift9 |
| Hide selected columns | Cmd0Ctrl0Ctrl0 |
| Unhide selected columns | CmdShift0CtrlShift0CtrlShift0 |
| Create table | CmdTCtrlTCtrlT |
| Insert hyperlink | CmdKCtrlKCtrlK |
Workbook & Sheet Management
| Action | Shortcut |
|---|---|
| New workbook | CmdNCtrlNCtrlN |
| Open workbook | CmdOCtrlOCtrlO |
| Save workbook | CmdSCtrlSCtrlS |
| Save As | CmdShiftSF12F12 |
| CmdPCtrlPCtrlP | |
| Close workbook | CmdWCtrlWCtrlW |
| Insert new worksheet | ShiftF11ShiftF11ShiftF11 |
| Delete current worksheet | CmdDeleteAltHDSAltHDS |
| Rename current worksheet | Double-click tabDouble-click tabDouble-click tab |
| Move or copy worksheet | AltHOMAltHOMAltHOM |
No shortcuts found. Try a different search term.
Frequently Asked Questions
What is the shortcut to quickly sum a range of cells in Excel?
On Windows, press Alt+= to insert an AutoSum formula. On Mac, use Cmd+Shift+T. Excel will automatically detect the adjacent range of numbers and insert a SUM function.
How do I switch between absolute and relative cell references in a formula?
While editing a formula, place your cursor on a cell reference and press F4. Each press cycles through the reference types: $A$1 (absolute), A$1 (mixed row), $A1 (mixed column), and A1 (relative).
How do I select all cells in a worksheet at once?
Press Cmd+A on Mac or Ctrl+A on Windows/Linux. Pressing it once selects the current data region, and pressing it again selects the entire worksheet.
What is the fastest way to navigate to the last cell with data in a large spreadsheet?
Press Ctrl+End on Windows/Linux or Ctrl+Fn+Right on Mac to jump to the last used cell. You can also use Ctrl+Arrow keys (Cmd+Arrow on Mac) to jump to the edge of data regions in any direction.
How do I enter the same data into multiple cells at once?
Select all the cells you want to fill (use Ctrl+Click to select non-adjacent cells), type your value, then press Ctrl+Enter (Cmd+Return on Mac) to fill all selected cells with the same data.