⌨️Excel Keyboard Shortcuts Directory
Excel Keyboard Shortcuts Reference
Essential Excel keyboard shortcuts organized by category. Toggle between Windows and macOS keys for instant reference.
⌨️|
Category Filter:Showing 15 of 15 shortcuts (Windows Keys)
Advertisement
| Shortcut Action | Category | Windows Keys | Description |
|---|---|---|---|
⌨️Move One Screen Right / Left | 🧭 Navigation | Alt+Page Down / Page Up | Scrolls the view horizontally one full screen to the right or left. |
⌨️Extend Selection to Cell A1 | 🧭 Navigation | Ctrl+Shift+Home | Extends selection of cells all the way back to cell A1. |
⌨️Extend Selection to Last Used Cell | 🧭 Navigation | Ctrl+Shift+End | Extends selection of cells to the last used cell in the worksheet. |
⌨️Select Visible Cells Only | 🎯 Selection | Alt+; | Selects only visible cells in a range, ignoring hidden rows or columns. |
⌨️Undo / Redo Last Action | ✏️ Editing & Data Entry | Ctrl+Z / Ctrl+Y | Reverses the last action (Undo) or reapplies it (Redo). |
⌨️Insert Current Date | ✏️ Editing & Data Entry | Ctrl+; | Inserts the static current date into active cell. |
⌨️Insert Current Time | ✏️ Editing & Data Entry | Ctrl+Shift+; | Inserts the static current time into active cell. |
⌨️Edit Active Cell | ✏️ Editing & Data Entry | F2 | Puts cursor inside active cell to edit contents directly. |
⌨️Spell Check Worksheet | ✏️ Editing & Data Entry | F7 | Runs spelling check across active worksheet. |
⌨️Minimize / Expand Excel Ribbon | 📑 Workbook & Sheets | Ctrl+F1 | Toggles ribbon menu collapsed or expanded to maximize screen work area. |
⌨️Create Official Excel Table | 📑 Workbook & Sheets | Ctrl+T / Ctrl+L | Converts selected range into a structured, styled official Excel Table. |
⌨️Save As Dialog | 📑 Workbook & Sheets | F12 | Opens Save As dialog to save workbook with new name or file type. |
⌨️Create Chart in New Sheet | 📑 Workbook & Sheets | F11 | Creates a column chart of selected data on a separate Chart Sheet. |
⌨️Open Name Manager | 🧮 Formulas | Ctrl+F3 | Opens Name Manager to view, edit, or delete defined cell ranges and names. |
⌨️Calculate Active Sheet Only | 🧮 Formulas | Shift+F9 | Calculates only formulas in the active worksheet. |
Advertisement