Microsoft Excel shortcut list: boost productivity
Microsoft Excel 2025, available in Office 2024 and Microsoft 365, is an essential tool for data analysis, budgeting, and reporting. Mastering the shortcuts (keyboard shortcuts) It allows you to work up to 50% faster, avoiding the constant use of the mouse.
This comprehensive guide lists the most useful shortcuts for beginners and advanced users, organized by category, with practical examples and tips for users in Spain looking to maximize efficiency in Windows 11 or Excel Online. Microsoft Teams vs. Zoom: Which is better?
Previous requirements
- Version: Excel 2024, Microsoft 365 or Excel Online.
- System: Windows 11/10 (until October 2025), macOS 12+ or web.
- LanguageConfigure Excel in Spanish (File > Options > Language) for localized shortcuts.
- Council: Uses Ctrl+` (grave accent) to display formulas in cells.
Essential navigation shortcuts
| Shortcut | Function | Example |
|---|---|---|
| Ctrl + Arrows | Go to the data edge | Jump from A1 to A100 if there is continuous data |
| Ctrl + Home | Go to A1 | Return to the beginning of the book |
| Ctrl + End | Go to the end of the data | It goes to the last cell with data. |
| F5 | Go to specific cell | Type B50 and press Enter |
| Ctrl + G | "Go to" box | Same as F5 |
| Ctrl + Page Up/Down | Change sheets | Navigate between tabs quickly |
object lessonIn a budget of 1,000 rows, use Ctrl + Down Arrow to reach the total in seconds.
Shortcuts for data selection
| Shortcut | Function | Example |
|---|---|---|
| Ctrl + A | Select all | The entire sheet or current range |
| Ctrl + Shift + Arrow | Select to edge | Select A1:A100 |
| Ctrl + Shift + Home | Select from cursor to A1 | Useful on large tables |
| Ctrl + Space | Select column | The entire current column |
| Shift + Space | Select row | The entire current row |
| Ctrl+Shift+L | Activate/deactivate filters | In pivot tables |
object lessonSelect a sales column with Ctrl + Space and applies formatting in one click.
Shortcuts for editing and formatting
| Shortcut | Function | Example |
|---|---|---|
| F2 | Edit cell | Modify formula directly |
| Ctrl + 1 | Cell format | Opens formatting window |
| Ctrl + B | Bold type | Quick title formatting |
| Ctrl + I | Italics | Emphasis on text |
| Ctrl + U | Underlined | Highlight headings |
| Ctrl + Shift + $ | Currency format (€) | Apply € to ranges |
| Ctrl + Shift + % | Percentage format | Ideal for margins |
| Alt+= | Autosum | Sum of selected range |
object lessonSelect B1:B12 and press Alt+= to total monthly expenses (€6,000).
Shortcuts for formulas and functions
| Shortcut | Function | Example |
|---|---|---|
| Ctrl + Shift + Enter | Matrix formula | For advanced calculations |
| F4 | Change references ($A$1) | Alternate between absolute/relative |
| Ctrl+` | Show/hide formulas | Check for errors |
| Alt + M + V | Paste Special > Values | Paste only results |
| Ctrl + Shift + A | Insert function arguments | After writing =SUM( |
| F3 | Paste defined name | In named ranks |
object lessonType =AVERAGE( and press Ctrl + Shift + A to see arguments.
Shortcuts for rows, columns, and sheets
| Shortcut | Function | Example |
|---|---|---|
| Ctrl+Shift++ | Insert row/column | Add row to table |
| Ctrl + - | Delete row/column | Clear selection |
| Ctrl + 9 | Hide row | Clean vision |
| Ctrl + 0 | Hide column | Hides sensitive data |
| Ctrl + Shift + ( | Show hidden rows | Recover data |
| Alt + ; | Select visible cells | In applied filters |
object lesson: Hides internal data columns with Ctrl + 0 before sharing.
Shortcuts for copying, pasting, and undoing
| Shortcut | Function | Example |
|---|---|---|
| Ctrl + C / V / X | Copy, paste, cut | Universal standard |
| Ctrl+Alt+V | Special glue | Choose values, formats |
| Ctrl + Z | Undo | Correct errors |
| Ctrl + Y | Redo | Recover action |
| Ctrl + D | Fill down | Copy the formula from above |
| Ctrl + R | Fill to the right | Copy to columns |
object lessonCopy a formula with Ctrl + C and paste it as a value with Ctrl + Alt + V > V.
Advanced shortcuts for analysis
| Shortcut | Function | Example |
|---|---|---|
| Ctrl + Shift + T | Create pivot table | From selected range |
| Alt + F1 | Quick Chart | Insert column chart |
| F11 | Chart on new sheet | visual analysis |
| Ctrl + Shift + P | Pivot table > Update | Refresh data |
| Alt + N + V | Insert pivot table | Quick menu |
object lessonSelect data and press Alt + F1 for an instant sales chart.
Shortcuts for saving and working with books
| Shortcut | Function | Example |
|---|---|---|
| Ctrl + S | Save | Standard |
| Ctrl + F12 | Save as | Choose location |
| Ctrl + N | New book | Open clean file |
| Ctrl + O | Open book | Existing load |
| Ctrl + W | Close book | Without closing Excel |
| F12 | Save As (Quick) | Export to PDF |
object lesson: Uses Ctrl + F12 to save as PDF before sending.
Tips for maximizing productivity in 2025
- Customize the quick access bar: Add Autosum, Conditional format with right-click.
- Use range namesSelect A1:A12 > Formulas > Define name > Use in formulas.
- Activate shortcuts in Excel OnlineThey work on Microsoft 365 web.
- Combines with mouse: Ctrl + click for non-contiguous selections.
- Upgrade to Office 2024: Includes AI shortcuts like Copilot (Ctrl + Shift + I).
ExampleName a range “Sales2025” and use =SUM(Sales2025) for clarity.
Shortcuts by category (quick summary)
| Category | Key shortcuts |
|---|---|
| Navigation | Ctrl + Arrows, Ctrl + Home/End |
| Selection | Ctrl + Shift + Arrow, Ctrl + Space |
| Format | Ctrl + 1, Ctrl + B/I/U |
| Formulas | Alt + =, F4, Ctrl + ` |
| Rows columns | Ctrl + Shift + +, Ctrl + 9/0 |
| Analysis | Alt + F1, Ctrl + Shift + T |
Conclusion
The shortcuts of Excel They are key to increasing productivity by 2025: Ctrl + Arrows to navigate, Alt+= to add up, F2 to edit and Ctrl + 1 for formatting. Practice the 10 most used (Ctrl + C/V, F2, Alt + =, Ctrl + Shift + LTo save hours each week. In Office 2024 or Microsoft 365, combine them with Copilot for AI-powered analytics. Master these shortcuts and make Excel an extension of your workflow.
FAQs
- Do they work in Excel for Mac?
Yes, use Cmd instead of Ctrl (Cmd + Arrows). - Are there shortcuts for Copilot?
Yes, Ctrl + Shift + I Open Copilot in Microsoft 365. - How do I see all the shortcuts?
Press Ctrl + / to search for commands. - Can I customize shortcuts?
Yes in File > Options > Customize Ribbon > Keyboard commands.
