Excel Shortcuts
In Excel, they keyboard can be used to perform almost every action available from the ribbons. These shortcut keys can help Excel users more efficiently produce value in their workbooks.
Review the list below for shortcuts that could benefit any Excel user.
Note: These shortcuts are not specific to Finsyte, but can be utilized in Excel for any workbook created.
Basic Shortcut Keys
| Shortcut | Description |
|---|
| F1 | Open Help |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + C | Copy |
| F4 | Repeat the last action |
| Ctrl + X | Cut |
| Ctrl + V | Paste |
| Ctrl + F | Find and Replace dialog with Find tab open |
| Ctrl + H | Find and Replace dialog with Replace tab open |
| Ctrl + T or Ctrl + L | Create Table |
| Shift + Space | Highlight entire row (or row within a table) |
| Ctrl + Space | Highlight entire column (or column within a table) |
| Ctrl + Shift + + | Insert new row or column based on selection |
| Ctrl + - | Delete selected row or column |
| Alt + H, O, H | Hide selected row or column |
| Alt + H, o, U | Unhide selected row or column |
| Ctrl + A | Highlight all cells in a sheet (or table when active cell is in the table) |
| Shift + Click | Expand Selection |
| Ctrl + Click | Add nonadjacent cells to selection |
| Ctrl + Shift + Arrow | Select to the edge of the active data region in the direction of the arrow |
Ribbon Shortcut Keys
| Shortcut | Description |
|---|
| Ctrl + F1 | Expand and collapse Ribbon |
| Alt | Activate Access keys in Ribbon |
Worksheet/Workbook Shortcut Keys
Worksheet
| Shortcut | Description |
|---|
| Shift + F11 | Insert new worksheet |
| Ctrl + PgDn | Go to next worksheet |
| Ctrl + PgUp | Go to previous worksheet |
| Alt + O, H, R | Rename current worksheet |
| Alt + E, L | Delete current worksheet |
| Alt + E, M | Move or copy current worksheet |
| Ctrl + P | Print |
| Ctrl + F2 | Open print preview |
| Alt + P, R, S | Set print area |
| Ctrl + Mouse Scroll Up | Zoom in |
| Ctrl + Mouse Scroll Out | Zoom out |
Workbook
| Shortcut | Description |
|---|
| Ctrl + N | Create new workbook |
| Ctrl + O | Open existing workbook |
| Ctrl + S | Save workbook |
| Ctrl + W | Close current workbook |
| Ctrl + F4 | Close Excel |
| Ctrl + Shift + F1 | Toggle Full Screen |
Navigation in Excel Shortcut Keys
| Shortcut | Description |
|---|
| PgDn | Move one screen down |
| PgUp | Move one screen up |
| Alt + PgDn | Move one screen right |
| Alt + PgUp | Move one screen left |
| Ctrl + Right Arrow | Move to the right edge of the data region |
| Ctrl + Left Arrow | Move to the left edge of the data region |
| Ctrl + Up Arrow | Move to the top edge of the data region |
| Ctrl + Down Arrow | Move to the bottom edge of the data region |
Active Cell Shortcut Keys
| Shortcut | Description |
|---|
| Enter | Move active cell down in selection - wrap to next column |
| Shift + Enter | Move active cell up in selection - wrap to previous column |
| Tab | Move active cell right in selection - wrap to next row |
| Shift + Tab | Move active cell left in selection - wrap to previous row |
| F2 | Edit active cell |
| Shift + F2 | Insert or edit a comment |
| Ctrl + ; | Insert Current Date |
| Ctrl + Shift + ; | Insert Current Time |
| Ctrl + D | Fill down from cell above |
| Ctrl + R | Fill right from cell on left |
| Ctrl + ' | Copy formula exactly from cell above |
| Ctrl + Shift + " | Copy value from cell above |
| Ctrl + K | Insert Hyperlink |
| Alt + N + U | Insert Symbol |
| Alt + W, E, F | Toggle Focus Cell highlighting on or off |
Cell Formatting Shortcut Keys
| Shortcut | Description |
|---|
| Ctrl + 1 | Open Format Cells |
| Ctrl + Shift + F | Display Format Cells with Font Tab selected |
| Ctrl + B | Add or remove bold |
| Ctrl + I | Add or remove italics |
| Ctrl + U | Add or remove underline |
| Ctrl + 5 | Add or remove strikethrough |
| Alt + H, A, C | Align Center |
| Alt + H, A, L | Align Left |
| Alt + H, A, R | Align Right |
| Alt + H, A, C | Align Center |
| Alt + H, 6 | Indent |
| Alt + H, 5 | Remove Indent |
| Alt + H, W | Wrap Text |
| Alt + H, A, T | Align Top |
| Alt + H, A, M | Align Middle |
| Alt + H, A, B | Align Bottom |
| Alt + H, F, G | Increase font by one step |
| Alt + H, F, K | Decrease font by one step |
Applying Borders Shortcut Keys
| Shortcut | Description |
|---|
| Alt + H + B | Open the list of border styles from the ribbon |
| Ctrl + Shift + & | Add a border around selected cells |
| Alt + H, B, R | Add or remove a right border |
| Alt + H, B, L | Add or remove a left border |
| Alt + H, B, P | Add or remove a top border |
| Alt + H, B, O | Add or remove a bottom border |
| Alt + H, B, A | Add all borders to all cells in selection |
| Ctrl + Shift + - | Remove borders |
Note: This is not an exhaustive list of every Excel shortkey, simply a list of some more useful ones.