The difference between a slow Excel user and a fast one isn't formulas — it's shortcuts. An MIS Executive who uses shortcuts saves 1-2 hours every day. In interviews, speed on Excel tests directly determines whether you pass or fail.
Navigation — Move Faster
- Ctrl + Home — jump to cell A1
- Ctrl + End — jump to the last used cell
- Ctrl + Arrow — jump to the edge of data in that direction
- Ctrl + G — Go To dialog (jump to any cell)
- Ctrl + Page Up / Page Down — switch between sheets
- F5 — Go To Special (select blanks, formulas, errors, etc.)
Selection — Select Like a Pro
- Ctrl + Shift + Arrow — select to the edge of data
- Ctrl + Shift + End — select from current cell to last used cell
- Ctrl + Space — select entire column
- Shift + Space — select entire row
- Ctrl + A — select all (or current data region)
- Ctrl + Shift + L — toggle filter on/off
Editing — Work Smarter
- Ctrl + C / V / X — copy / paste / cut
- Ctrl + Z / Y — undo / redo
- Ctrl + D — fill down (copy cell above)
- Ctrl + R — fill right (copy cell to the left)
- Ctrl + ; — insert today's date
- Ctrl + Shift + : — insert current time
- F2 — edit cell (enter edit mode)
- Alt + Enter — new line inside a cell
- Ctrl + Shift + "+" — insert cells/rows/columns
- Ctrl + "-" — delete cells/rows/columns
- Ctrl + H — Find and Replace
Formatting — Look Professional
- Ctrl + B — bold
- Ctrl + I — italic
- Ctrl + U — underline
- Ctrl + 1 — Format Cells dialog (the most powerful shortcut)
- Ctrl + Shift + $ — currency format
- Ctrl + Shift + % — percentage format
- Ctrl + Shift + # — date format
- Ctrl + Shift + ~ — general format (remove formatting)
- Alt + H + O + I — auto-fit column width
Formula Shortcuts — Type Faster
- Alt + = — AutoSum (instantly adds SUM formula)
- F4 — toggle between A1, $A$1, A$1, $A1 (absolute/relative)
- Tab — accept autocomplete suggestion
- Ctrl + ` — show all formulas in the sheet (toggle)
- Ctrl + Shift + Enter — enter as array formula (legacy)
- F9 — evaluate part of formula (select a portion in the formula bar, press F9)
- Ctrl + [ — trace precedents (which cells feed into this formula)
Data & Files
- Ctrl + S — save
- Ctrl + N — new workbook
- Ctrl + O — open file
- Ctrl + P — print
- Ctrl + T — convert data to Table
- Alt + D + S — sort dialog
- Ctrl + Shift + L — toggle AutoFilter
- Alt + N + V — insert Pivot Table
The Top 10 Most Impactful Shortcuts
If you learn nothing else, learn these. They account for the biggest time savings:
- Ctrl + Arrow — navigate large datasets instantly
- Ctrl + Shift + Arrow — select large ranges instantly
- F4 — lock cell references without typing $ manually
- Ctrl + D — fill down without copy-paste
- Alt + = — autosum in one keystroke
- Ctrl + 1 — format anything (numbers, dates, alignment, borders)
- Ctrl + Shift + L — add/remove filters instantly
- Ctrl + ; — today's date without typing
- Ctrl + ` — audit all formulas at once
- Ctrl + H — find and replace data errors in bulk
How to Build Shortcut Muscle Memory
- Pick 5 shortcuts this week. Use them every time, even if it feels slower at first.
- Next week, add 5 more.
- Within a month, you'll be noticeably faster than colleagues who use the mouse for everything.
- Practice in Verma Learning — solving formula questions under time pressure forces you to use shortcuts.
Practice Excel at Speed
Verma Learning's practice format — load question, type formula, submit — naturally builds speed. The more you practice, the faster your shortcuts become.
Download Free — vermalearning.com