Using shortcut keys in Excel can save you a lot of time and help you work faster and smarter. Whether you are entering data, formatting cells, or navigating your worksheet, there are many useful Excel shortcuts that make these tasks easier. In this blog, you will find 50 important Excel shortcut keys for 2023 that are simple and handy, helping you become more efficient with Excel.
✍️ Key Categories of Excel Shortcuts
Here are some shortcut categories before diving into the list:
- Frequently Used / File Operations
- Navigation & Selection
- Editing & Data Entry
- Formatting
- Formulas / Function Keys
🔟 Frequently Used / File Operations
- Ctrl + N — Create a new workbook
- Ctrl + O — Open an existing workbook
- Ctrl + S — Save the current workbook
- Ctrl + W — Close the current workbook or window
- Ctrl + P — Open the print dialog / print options
- Ctrl + Z — Undo the last action
- Ctrl + Y — Redo the previously undone action
- Ctrl + X — Cut the selected content
- Ctrl + C — Copy the selected content
- Ctrl + V — Paste the copied or cut content
🔟 Navigation & Selection
- Ctrl + Arrow Key — Jump to the edge of the current data region
- Ctrl + Home — Go to the first cell of the worksheet
- Ctrl + End — Move to the last used cell on the worksheet
- Ctrl + Shift + Arrow Key — Extend selection of cells in that direction
- Ctrl + A — Select all cells in the worksheet (or region)
- Ctrl + Page Up — Move to the previous sheet in the workbook
- Ctrl + Page Down — Move to the next sheet in the workbook
- Shift + F8 — Add a non-adjacent cell or range to a selection
- F8 — Turn Extend Mode on/off to use arrow keys to extend a selection
- Alt + Enter — Start a new line in the same cell (while editing)
🔟 Editing & Data Entry
- Ctrl + Enter — Fill the selected cells with the current input
- Ctrl + ; (semicolon) — Insert current date in a cell
- Ctrl + Shift + : (colon) — Insert current time in a cell
- F2 — Edit the active cell (or formula)
- Ctrl + D — Fill down from the cell above
- Ctrl + R — Fill right from the cell to the left
- Ctrl + ‘ (apostrophe) — Copy formula from the cell above
- Ctrl + K — Insert a hyperlink in the selected cell
- Ctrl + Shift + ” (quote) — Copy the value from the cell above (without formula)
- Ctrl + Shift + A — Insert function argument names and parentheses in a formula
🔟 Formatting
- Ctrl + 1 — Open Format Cells dialog box
- Ctrl + B — Toggle bold formatting
- Ctrl + I — Toggle italic formatting
- Ctrl + U — Toggle underline formatting
- Ctrl + 5 — Apply strikethrough to selected cells
- Ctrl + Shift + & — Apply outline border to selected cells
- Ctrl + Shift + _ — Remove outline border from cells
- Ctrl + Shift + ~ — Apply General number format
- Ctrl + Shift + $ — Apply Currency format
- Ctrl + Shift + % — Apply Percent format
🔟 Formulas / Function Keys
- Alt + = — Auto-sum selected cells (Insert SUM function)
- F4 — Repeat last command or cycle cell reference types in a formula
- Alt + F1 — Create a chart of the selected data in the same sheet
- F11 — Create a chart of selected data on a new sheet
- Ctrl + Shift + Enter — Enter an array formula (legacy method)
- Shift + F3 — Insert a function (opens Insert Function dialog)
- F9 — Recalculate all worksheets in all open workbooks
- Ctrl + ` (grave accent) — Toggle display of formulas instead of results in cells
- F7 — Spell-check selected worksheet
- Alt + F4 — Close Excel application
✅ Final Thoughts
These 50 keyboard shortcuts will help boost your efficiency in Excel, whether you’re editing data fast, formatting spreadsheets, navigating large worksheets, or working with formulas. Learning even a fraction of them can shave off minutes from your daily tasks — which add up to serious productivity over time.
Mastering shortcuts is a key skill for anyone serious about Excel, whether you’re a student, analyst, manager, or financial pro.
