Excel Keyboard Shortcuts | Essential Shortcuts to Work Faster
.svg){kind=small}
Essential Excel Keyboard Shortcuts: Quick Reference
Keyboard shortcuts can make everyday Excel work much faster by reducing the time spent moving between the keyboard, mouse and Ribbon. The shortcuts below are for Excel for Windows desktop. Some shortcuts differ on macOS, Excel for the web and non-US keyboard layouts.
- Ctrl + C / X / V — Copy, cut and paste
- Ctrl + Z / Y — Undo and redo
- Ctrl + S — Save the workbook
- Ctrl + F — Find text, numbers or formulas
- Ctrl + Arrow key — Jump to the edge of a data region
- Ctrl + Shift + Arrow key — Extend a selection to the edge of a data region
- F2 — Edit the active cell
- Ctrl + 1 — Open Format Cells
- Ctrl + T — Create an Excel Table
- Ctrl + Shift + L — Add or remove filters
- Alt + = — Insert AutoSum
- F4 — Cycle through relative and absolute references while editing a formula
- Ctrl + ` — Show or hide formulas
- Ctrl + Alt + V — Open Paste Special
- Ctrl + D / Ctrl + R — Fill down or fill right
- Ctrl + ; — Enter the current date
- Ctrl + Shift + : — Enter the current time
- Ctrl + E — Apply Flash Fill
Why Learn Excel Keyboard Shortcuts?
Microsoft Excel contains hundreds of commands, but you do not need to memorise them all. Learning a small set of shortcuts for the tasks you repeat most often can improve speed, accuracy and confidence.
The greatest benefit usually comes from shortcuts for navigation, selecting data, editing formulas, formatting, filtering and copying data. Once these become automatic, you can work through large spreadsheets with much less interruption.
1. Navigation Shortcuts
These are especially useful when you are working with long lists or large datasets.
- Ctrl + Arrow key — Move to the edge of the current data region.
- Ctrl + Home — Move to cell A1.
- Ctrl + End — Move to the last used cell on the worksheet.
- Page Up / Page Down — Move one screen up or down.
- Alt + Page Up / Page Down — Move one screen left or right.
- Ctrl + Page Up / Page Down — Move to the previous or next worksheet.
Tip: Add Shift to many navigation shortcuts when you want to select cells as you move.
2. Selecting Data
- Ctrl + A — Select the current data region; repeated presses can expand the selection to the whole worksheet depending on context.
- Shift + Space — Select the entire row.
- Ctrl + Space — Select the entire column.
- Shift + Arrow key — Extend the selection one cell at a time.
- Ctrl + Shift + Arrow key — Extend the selection to the last non-blank cell in that direction.
- Ctrl + Shift + Home — Extend the selection to the beginning of the worksheet.
- Ctrl + Shift + End — Extend the selection to the last used cell.
3. Editing and Data Entry Shortcuts
- F2 — Edit the active cell.
- Ctrl + Z — Undo the most recent action.
- Ctrl + Y — Redo or repeat an action where supported.
- Ctrl + C / Ctrl + X / Ctrl + V — Copy, cut and paste.
- Ctrl + Enter — Enter the same value or formula into all selected cells.
- Alt + Enter — Insert a line break inside a cell.
- Ctrl + D — Fill the selected cells down using the top cell.
- Ctrl + R — Fill the selected cells to the right using the leftmost cell.
- Ctrl + ; — Enter today's date.
- Ctrl + Shift + : — Enter the current time.
- Ctrl + E — Use Flash Fill to recognise and continue a pattern.
4. Formatting Shortcuts
- Ctrl + B — Apply or remove bold.
- Ctrl + I — Apply or remove italic.
- Ctrl + U — Apply or remove underline.
- Ctrl + 1 — Open the Format Cells dialog box.
- Ctrl + Shift + $ — Apply Currency format.
- Ctrl + Shift + % — Apply Percentage format.
- Ctrl + Shift + # — Apply Date format.
Tip: Ctrl + 1 is one of the most useful Excel shortcuts because the Format Cells dialog gives quick access to number formats, alignment, fonts, borders, fills and protection settings.
5. Formula Shortcuts
- = — Start a formula.
- Alt + = — Insert AutoSum.
- F4 — When a cell reference is selected inside a formula, cycle through relative and absolute reference combinations such as A1, $A$1, A$1 and $A1.
- Ctrl + ` — Switch between displaying formula results and the formulas themselves.
- Shift + F3 — Open Insert Function.
- F9 — Calculate all worksheets in all open workbooks.
- Shift + F9 — Calculate the active worksheet.
Tip: F4 behaves differently when you are not editing a formula, so make sure the insertion point is on or next to the cell reference you want to change.
6. Tables, Filters and Data Shortcuts
- Ctrl + T — Open the Create Table dialog box.
- Ctrl + Shift + L — Add or remove AutoFilter.
- Ctrl + Q — Display Quick Analysis for a selected range containing data.
- Ctrl + E — Apply Flash Fill.
- Ctrl + Alt + F5 — Refresh all external data in the workbook.
Excel Tables are particularly useful because they automatically expand, provide structured references and make filtering and formatting easier.
7. Insert and Delete Shortcuts
- Ctrl + Shift + + — Open the Insert dialog box for cells, rows or columns.
- Ctrl + - — Open the Delete dialog box for selected cells, rows or columns.
- Shift + F11 — Insert a new worksheet.
On many keyboards, entering the plus sign requires Shift, which is why the insert command is commonly shown as Ctrl + Shift + +.
8. Workbook and Worksheet Shortcuts
- Ctrl + N — Create a new workbook.
- Ctrl + O — Open a workbook.
- Ctrl + S — Save the current workbook.
- Ctrl + W — Close the current workbook.
- Ctrl + Page Up / Page Down — Move between worksheets.
- Shift + F11 — Insert a new worksheet.
9. Paste Special Shortcuts
Paste Special is one of Excel's most useful productivity tools because it lets you paste only the part of copied data you need.
- Ctrl + Alt + V — Open the Paste Special dialog box.
- After opening Paste Special, press V to choose Values.
- Press T to paste Formats only.
- Press F to paste Formulas only.
This is safer and easier to remember than relying on older legacy menu-key sequences.
10. Time-Saving Shortcut Combinations
Scenario 1: Clean and Structure a Dataset
- Click inside the dataset.
- Use Ctrl + A to select the current region.
- Use Ctrl + T to convert it to an Excel Table.
- Use Ctrl + Shift + L if you need to add or remove filters.
- Use Ctrl + 1 to apply consistent number or date formatting.
Scenario 2: Build and Copy a Formula
- Type = and build the formula.
- Use F4 on references that need to remain fixed.
- Press Enter to complete the formula.
- Select the formula and destination cells, then use Ctrl + D to fill down.
Scenario 3: Fast Data Entry
- Use Ctrl + Arrow keys to move quickly through the data.
- Use Ctrl + ; to enter today's date where needed.
- Use Ctrl + Enter to put the same entry into several selected cells.
- Use Ctrl + E when Flash Fill can recognise a repeating pattern.
How to Memorise Excel Keyboard Shortcuts
You do not need to learn dozens at once. A more effective approach is to choose a few shortcuts that replace actions you perform repeatedly.
- Start with five: Ctrl + Arrow, F2, Ctrl + 1, Ctrl + T and Ctrl + Alt + V are a strong starting set.
- Practise them deliberately: avoid reaching for the mouse when you know a shortcut exists.
- Add new shortcuts gradually: once a shortcut becomes automatic, add another.
- Use Ribbon Key Tips: press Alt in Excel to display the access keys for Ribbon commands.
- Keep a personal cheat sheet: list only the shortcuts that match the work you actually do.
Final Thoughts
Excel keyboard shortcuts are most valuable when they remove friction from tasks you perform every day. Navigation, selection, editing, formatting, formulas, tables and Paste Special are excellent areas to focus on first.
You do not need to become a walking shortcut dictionary. Learn the commands that support your normal workflow, use them consistently, and add new ones as your Excel skills develop.
Want to Build Your Excel Skills Further?
Keyboard shortcuts are only one part of working efficiently in Excel. Explore our Excel training pathway to compare core, advanced, Power Query, data modelling and VBA courses.
Not sure which level is right for you? Take our free Excel Skills Assessment for an instant starting-point recommendation.
Want to work faster and more confidently in Excel? Explore our Excel training pathway, from core skills through advanced formulas, Power Query, data modelling and VBA.
Found this article useful? Add ExperTrain as a Preferred Source on Google to help surface more of our training guides, articles and learning resources.
.png){kind=small}
