Excel Shortcut Key part 5
| Excel Shortcut Key part 5 | |
| Shortcut | Description |
| Ctrl+Shift+! | Applies comma formatting. |
| Ctrl+Shift+$ | Applies currency formatting. |
| Ctrl+Shift+# | Applies date formatting. |
| Ctrl+Shift+% | Applies percentage formatting. |
| Ctrl+Shift+^ | Applies exponential formatting. |
| Ctrl+Shift+* | Selects the current region around the active cell. |
| Ctrl+Shift+& | Places border around selected cells. |
| Ctrl+Shift+_ | Removes a border. |
| Ctrl++ | Insert. |
| Ctrl+- | Delete. |
| Ctrl+Shift+( | Unhide rows. |
| Ctrl+Shift+) | Unhide columns. |
| Ctrl+/ | Selects the array containing the active cell. |
| Ctrl+\ | Selects the cells that have a static value or don’t match the formula in the active cell. |
| Ctrl+[ | Selects all cells referenced by formulas in the highlighted section. |
| Ctrl+] | Selects cells that contain formulas that reference the active cell. |
| Ctrl+Shift+{ | Selects all cells directly or indirectly referenced by formulas in the highlighted section. |
| Ctrl+Shift+} | Selects cells which contain formulas that directly or indirectly reference the active cell. |
| Ctrl+Shift+| (pipe) | Selects the cells within a column that don’t match the formula or static value in the active cell. |
| Ctrl+Enter | Fills the selected cells with the current entry. |
| Ctrl+Spacebar | Selects the entire column. |
| Ctrl+Shift+Spacebar | Selects the entire worksheet. |
| Ctrl+Home | Move to cell A1. |
| Ctrl+End | Move to last cell on worksheet. |
| Ctrl+Tab | Move between Two or more open Excel files. |
| Ctrl+Shift+Tab | Activates the previous workbook. |
| Ctrl+Shift+A | Inserts argument names into a formula. |
| Ctrl+Shift+F | Opens the drop-down menu for fonts. |
| Ctrl+Shift+O | Selects all of the cells that contain comments. |
| Ctrl+Shift+P | Opens the drop-down menu for point size. |
| Shift+Insert | Pastes what is stored on the clipboard. |
| Shift+Page Up | In a single column, highlights all cells above that are selected. |
| Shift+Page Down | In a single column, highlights all cells above that are selected. |
| Shift+Home | Highlights all text to the left of the cursor. |
| Shift+End | Highlights all text to the right of the cursor. |
| Shift+Up Arrow | Extends the highlighted area up one cell. |
| Shift+Down Arrow | Extends the highlighted area down one cell. |
| Shift+Left Arrow | Extends the highlighted area left one character. |
| Shift +Right Arrow | Extends the highlighted area right one character. |
| Alt+Tab | Cycles through applications. |
| Alt+Spacebar | Opens the system menu. |
| Alt+Backspace | Undo. |
| Alt+Enter | While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell. |