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