Excel Shortcuts
PC (Windows) Shortcuts & Mac Shortcuts
Editing shortcuts
| Edit active cell | ||
| Cut | ||
| Copy | ||
| Paste | ||
| Paste Special | ||
| Paste name into formula | ||
| Toggle references | ||
| Start a new line within the same cell | ||
| Insert or edit cell comment | ||
| Display shortcut menu (i.e. same as right click) | ||
| Insert worksheet | ||
| Define a name for a cell | ||
| Fill down (e.g. copy formula down in selected cells) | ||
| Fill right | ||
| Insert argument names and parentheses for a function after typing a function name in a formula | ||
| Insert row | ||
| Insert column |
Formatting Shortcuts
| Brings up format cells menu | ||
| Bold | ||
| Italic | ||
| Undo | ||
| Redo | ||
| Repeat last action | ||
| Select all used cells (select entire worksheet if command is repeated) | ||
| Number format | ||
| Date format | ||
| Percent format | ||
| Increase font size | ||
| Decrease font size | ||
| Increase decimal | ||
| Decrease decimal | ||
| Increase indent | ||
| Decrease indent |
Navigation Shortcuts
| Move from cell to cell | ||
| Go to | ||
| Go to cell A1 | ||
| Go to beginning of row | ||
| Select the adjacent cell | ||
| Select entire row | ||
| Select entire column | ||
| Select all to the start of the sheet | ||
| Select all to the last used cell of the sheet | ||
| Select to the end of the last used cell in row/column | ||
| Select the last used cell in row/column | ||
| Move one screen up | ||
| Move one screen down | ||
| Move one screen left | ||
| Move one screen right | ||
| Move to the next or previous worksheet (Move between tabs if you are in a menu window) | ||
| Move to next workbook (while in spreadsheet) Move to next divider (when in menu options) | ||
| Move to the next cell (Move between items within a menu window) |
File Shortcuts
| New | ||
| Open | ||
| Save workbook | ||
| Save As | ||
| Open print preview window | ||
| Go to next workbook | ||
| Close file | ||
| Close all open Excel files |
Ribbon Shortcuts
| Show ribbon accelerator keys | ||
| Show/hide ribbon |
Paste Special Shortcuts
| Paste Special formats | ||
| Paste Special values | ||
| Paste Special formulas | ||
| Paste Special comments |
Clear Shortcuts
| Clear cell data | ||
| Clear cell formats | ||
| Clear cell comments | ||
| Clear all (data, formats, comments) |
Selection Shortcuts
| Select a cell range | ||
| Highlight a contiguous range | ||
| Extend selection up one screen | ||
| Extend selection down one screen | ||
| Extend selection left one screen | ||
| Extend selection right one screen | ||
| Select all |
Data Editing Shortcuts
| Fill down from cell above | ||
| Fill right from cell left | ||
| Find and replace | ||
| Show all constants | ||
| Highlight cells with comments |
Data Editing (inside cell) Shortcuts
| Edit the active cell (edit mode) | ||
| While editing cell, allow use of arrow keys to create reference | ||
| Confirm change and get out of cell | ||
| Cancel a cell entry and get out of cell | ||
| Insert line break within cell | ||
| Highlight within a cell | ||
| Highlight contiguous items | ||
| Jump to beginning of cell contents | ||
| Jump to end of cell contents | ||
| Delete character to left | ||
| Delete character to right | ||
| Accept autocomplete suggestion | ||
| Referencing a cell from another worksheet |
Other Shortcuts
| Enter date | ||
| Enter time | ||
| Show formula/show values (key to the left of 1) | ||
| Select cells which refer to the active cell (useful before deleting a cell in a worksheet) | ||
| Drives menu bar | ||
| Next open program | ||
| Autosum |
Source: CFI