productivity
excel
tips
2 min de lectura10 Excel Shortcuts Every Developer Should Know
You don't use Excel every day — but when you do, these keyboard shortcuts will save you hours. No mouse required.
10 Excel Shortcuts Every Developer Should Know
We write code for a living — but spreadsheets happen. Whether it's analyzing query results, sharing data with non-technical stakeholders, or doing a quick financial model, Excel (or Google Sheets) shows up.
Here are the 10 shortcuts that eliminate most of the friction.
Navigation
| Shortcut | Action |
|---|---|
Ctrl + End | Jump to the last used cell |
Ctrl + Home | Jump to A1 |
Ctrl + Arrow | Jump to the edge of a data range |
Ctrl + Shift + Arrow | Select to the edge of a data range |
Data Entry
| Shortcut | Action |
|---|---|
Ctrl + D | Fill Down |
Ctrl + R | Fill Right |
Alt + Enter | New line inside a cell |
Ctrl + ; | Insert today's date |
Formatting
| Shortcut | Action |
|---|---|
Ctrl + 1 | Open Format Cells dialog |
Ctrl + Shift + L | Toggle AutoFilter |
The One You'll Use Most
Ctrl + Shift + Enter — array formula (Excel 365 handles this automatically with dynamic arrays, but in older versions this is essential).
Bookmark this post. You'll thank yourself next time you're knee-deep in a spreadsheet at 11pm.