Tip: Some shortcut keys may behave differently by software version, operating system or keyboard layout.
About Excel Shortcut Keys
Excel shortcut keys help you work faster with rows, columns, formulas, filters, worksheets and data tables. These shortcuts are useful for office work, accounting, reports, school projects and data entry jobs.
Shortcut keys reduce mouse movement and make repeated tasks faster. They are useful for typing, editing, browsing, file management, coding, designing and office work.
Excel Shortcut Keys List
| Shortcut Key | Use | Works In | Example |
|---|---|---|---|
| Ctrl + Arrow Key | Move to edge of data region | Excel | Jump to last filled cell in a direction. |
| Ctrl + Shift + Arrow | Select data region | Excel | Select many cells quickly. |
| Ctrl + Space | Select entire column | Excel | Select the current column. |
| Shift + Space | Select entire row | Excel | Select the current row. |
| Ctrl + 1 | Open Format Cells dialog | Excel | Change number, alignment and font formatting. |
| Ctrl + T | Create table | Excel | Convert selected range into a table. |
| Ctrl + Shift + L | Turn filter on/off | Excel | Add filters to headers. |
| Alt + = | AutoSum | Excel | Insert SUM formula automatically. |
| F2 | Edit active cell | Excel | Edit cell content without double-click. |
| F4 | Repeat last action or toggle references | Excel | Change A1 to $A$1 inside formulas. |
| Ctrl + ` | Show formulas | Excel | Display formulas instead of results. |
| Ctrl + Page Up | Move to previous sheet | Excel | Switch worksheets. |
| Ctrl + Page Down | Move to next sheet | Excel | Switch worksheets. |
| Shift + F11 | Insert new worksheet | Excel | Add a blank sheet. |
| Ctrl + ; | Insert current date | Excel | Add today date. |
| Ctrl + Shift + : | Insert current time | Excel | Add current time. |
How to remember these shortcuts
- Practice shortcuts inside real tasks instead of memorizing only lists.
- Group shortcuts by action: copy-paste, formatting, navigation, screenshots and search.
- Keep a small cheat sheet until the shortcuts become muscle memory.
- Use the search page whenever you forget a shortcut.
FAQs
Do these shortcuts work in every app?
No. Many shortcuts are common, but some are specific to Windows, Mac, browsers or individual software.
Which shortcuts should beginners learn first?
Beginners should start with copy, paste, cut, undo, save, print, find and select all.
What is the Mac alternative for Ctrl shortcuts?
Many Mac shortcuts use Command instead of Ctrl, such as Command + C for copy and Command + V for paste.