Shortcut Keys Guide
Microsoft Excel & PDF Shortcut Keys
Microsoft Excel Shortcut Keys
| Function | Shortcut (Windows) | Shortcut (Mac) |
|---|---|---|
| Copy | Ctrl + C | ⌘ + C |
| Cut | Ctrl + X | ⌘ + X |
| Paste | Ctrl + V | ⌘ + V |
| Undo | Ctrl + Z | ⌘ + Z |
| Redo | Ctrl + Y | ⌘ + Y or ⌘ + Shift + Z |
| Edit active cell | F2 | Control + U |
| Insert line break in cell | Alt + Enter | Control + Option + Enter |
| Insert function | Shift + F3 | Shift + Fn + F3 |
| Select entire row | Shift + Space | Shift + Space |
| Select entire column | Ctrl + Space | ⌘ + Space |
| Go to beginning of worksheet | Ctrl + Home | ⌘ + Home (or Command + ↑) |
| Go to last cell with data | Ctrl + End | ⌘ + End (or Command + ↓) |
| Switch between worksheets | Ctrl + Page Up/Page Down | ⌘ + Page Up/Page Down |
| Open Format Cells dialog | Ctrl + 1 | ⌘ + 1 |
| Toggle AutoFilter | Ctrl + Shift + L | ⌘ + Shift + L |
| Repeat last action | F4 | ⌘ + Y |
| Insert current date | Ctrl + ; | Control + ; |
| Insert current time | Ctrl + Shift + ; | Control + Shift + ; |
| Insert new worksheet | Shift + F11 | Shift + Fn + F11 |
| Delete current worksheet | Alt + E, L | Control + – (when sheet is selected) |
| AutoSum | Alt + = | ⌘ + Shift + T |
| Insert comment | Shift + F2 | Shift + Fn + F2 |
| Display Insert Function dialog | Shift + F3 | Shift + Fn + F3 |
PDF Shortcut Keys
| Action | Windows/UNIX | macOS |
|---|---|---|
| Previous screen | Page Up or Shift + Enter | Page Up or Shift + Return |
| Next screen | Page Down or Enter | Page Down or Return |
| First page | Home or Shift + Ctrl + Page Up or Shift + Ctrl + Up Arrow | Home or Shift + Command + Up Arrow |
| Last page | End or Shift + Ctrl + Page Down or Shift + Ctrl + Down Arrow | End or Shift + Command + Down Arrow |
| Previous page | Left Arrow or Ctrl + Page Up | Left Arrow or Command + Page Up |
| Next page | Right Arrow or Ctrl + Page Down | Right Arrow or Command + Page Down |
| Go to page | Ctrl + Shift + N | Command + Shift + N |
| Scroll up | Up Arrow | Up Arrow |
| Scroll down | Down Arrow | Down Arrow |
| Zoom in | Ctrl + Equal sign | Command + Equal sign |
| Zoom out | Ctrl + Hyphen | Command + Hyphen |