Speed in Excel separates beginners from professionals. An MIS Executive who uses shortcuts saves 1-2 hours every day. In timed interview tests, shortcuts are the difference between finishing and running out of time. Here are 100 shortcuts every Excel user must know.
Pro Tip: Don't try to memorize all 100 at once. Pick 5 per week. Force yourself to use them even when it feels slower. Within 3 weeks, they become automatic.
#What It DoesShortcutTip / When to Use
NAVIGATION — Move Around Faster
1Go to cell A1Ctrl + HomeStart of any audit or review
2Go to last used cellCtrl + EndFind where data ends
3Jump to edge of dataCtrl + ArrowNavigate 10,000 rows in 1 keystroke
4Go to a specific cellCtrl + GType cell address, press Enter
5Go To Special dialogF5Select blanks, errors, formulas only
6Next worksheetCtrl + Page DownFlip between monthly sheets fast
7Previous worksheetCtrl + Page UpGo back to previous sheet
8Scroll without moving cellScroll Lock + ArrowsView data without losing your place
9Move to next cell (right)TabFaster than Arrow in data entry
10Move to previous cellShift + TabGo back one cell during entry
SELECTION — Select Like a Pro
11Select to edge of dataCtrl + Shift + ArrowSelect entire column of data instantly
12Select to last used cellCtrl + Shift + EndSelect everything from here to the end
13Select entire columnCtrl + SpaceThen Ctrl+- to delete the column
14Select entire rowShift + SpaceThen Ctrl+- to delete the row
15Select all / current regionCtrl + ASelects data table first, then all
16Extend selection by one cellShift + ArrowPrecise selection control
17Select non-adjacent cellsCtrl + ClickSelect multiple separate ranges
18Select visible cells onlyAlt + ;Copy filtered data without hidden rows
19Select current arrayCtrl + /Find the extent of an array formula
20Select cells with commentsCtrl + Shift + OFind all annotated cells
EDITING — Work Smarter, Not Harder
21CopyCtrl + CUniversal — works everywhere
22PasteCtrl + VPastes with formatting by default
23Paste SpecialCtrl + Alt + VPaste values only, formats only, etc.
24CutCtrl + XMove data without copy+delete
25UndoCtrl + ZUp to 100 levels of undo
26RedoCtrl + YRedo what you just undid
27Fill downCtrl + DCopy cell above — faster than copy-paste
28Fill rightCtrl + RCopy cell to the left
29Edit cellF2Enter edit mode without double-clicking
30Delete cell contentDeleteClears content, keeps formatting
31Delete everythingCtrl + Shift + DeleteClears content AND formatting
32Insert cells/rows/columnsCtrl + Shift + +After selecting row: inserts row above
33Delete cells/rows/columnsCtrl + -After selecting row: deletes that row
34New line in cellAlt + EnterMulti-line text inside one cell
35FindCtrl + FSearch current sheet or all sheets
36Find and ReplaceCtrl + HBulk fix data errors in seconds
37Repeat last actionF4 (outside formula)Apply same formatting to another cell
38Insert current dateCtrl + ;Static date — doesn't change
39Insert current timeCtrl + Shift + :Static time — doesn't change
40Flash FillCtrl + EAuto-detect pattern and fill column
FORMATTING — Look Professional
41BoldCtrl + BHeaders and totals
42ItalicCtrl + INotes and subtitles
43UnderlineCtrl + UTotals row in reports
44StrikethroughCtrl + 5Mark completed items
45Format Cells dialogCtrl + 1The most powerful formatting shortcut
46Currency formatCtrl + Shift + $Apply ₹ or $ format instantly
47Percentage formatCtrl + Shift + %Converts 0.15 to 15%
48Number format (commas)Ctrl + Shift + !1234567 becomes 12,34,567
49Date formatCtrl + Shift + #Serial number becomes date
50General formatCtrl + Shift + ~Remove all number formatting
51Add border (outline)Ctrl + Shift + &Quick border around selection
52Remove bordersCtrl + Shift + _Clear all borders
53Auto-fit column widthAlt + H, O, IFit column to widest content
54Auto-fit row heightAlt + H, O, AFit row to tallest content
55Increase font sizeAlt + H, F, GOne step bigger
FORMULAS — Type Faster, Debug Better
56AutoSumAlt + =Instant SUM formula — the #1 time saver
57Toggle absolute referenceF4 (in formula)Cycles: A1 → $A$1 → A$1 → $A1
58Accept autocompleteTabWhen Excel suggests a function name
59Show all formulasCtrl + `Toggle between values and formulas
60Enter array formulaCtrl + Shift + EnterLegacy CSE arrays (pre-365)
61Evaluate formula partF9 (in formula bar)Select part of formula, press F9 to see result
62Insert function dialogShift + F3Browse all functions with help text
63Function arguments dialogCtrl + A (in formula)After typing =VLOOKUP( press Ctrl+A
64Trace precedentsCtrl + [Which cells feed into this formula?
65Trace dependentsCtrl + ]Which cells use this cell?
66Name ManagerCtrl + F3Create/edit named ranges
67Define name from selectionCtrl + Shift + F3Auto-create names from headers
68Calculate all workbooksF9Force recalculation
69Calculate current sheetShift + F9Faster than full recalc
70Enter formula in all selectedCtrl + EnterSame formula in 100 cells at once
DATA MANAGEMENT — Handle Data Like a Pro
71Toggle AutoFilterCtrl + Shift + LAdd/remove filters instantly
72Convert to TableCtrl + TStructured references, auto-expand
73Sort ascendingAlt + D, SOpens Sort dialog
74Insert Pivot TableAlt + N, VCreate Pivot from selected data
75Group rows/columnsAlt + Shift + RightCollapse/expand sections
76Ungroup rows/columnsAlt + Shift + LeftRemove grouping
77Data ValidationAlt + D, LCreate dropdowns and rules
78Remove duplicatesAlt + A, MData tab → Remove Duplicates
79Text to ColumnsAlt + D, ESplit one column into multiple
80Freeze panesAlt + W, F, FKeep headers visible while scrolling
WORKBOOK & FILE — Manage Files Fast
81SaveCtrl + SSave every 5 minutes — never lose work
82Save AsF12Save with different name/format
83New workbookCtrl + NBlank workbook opens instantly
84Open fileCtrl + OOpen any Excel file
85PrintCtrl + PPrint preview and print
86Close workbookCtrl + WClose file, keep Excel open
87Switch between workbooksCtrl + TabWhen multiple files are open
88Insert new worksheetShift + F11New blank sheet added
89Rename sheetDouble-click tabOr right-click → Rename
90Move/copy sheetCtrl + Drag tabHold Ctrl while dragging to copy
ADVANCED — Power User Tricks
91Insert chartAlt + F1Instant chart from selected data
92Insert chart in new sheetF11Full-page chart sheet
93Spell checkF7Check spelling before sending reports
94ThesaurusShift + F7Find alternative words
95Insert commentShift + F2Add notes to cells
96Show/hide ribbonCtrl + F1More screen space for data
97VBA EditorAlt + F11Open macro editor
98Run macroAlt + F8Open macro dialog
99Full screen toggleCtrl + Shift + F1Maximize workspace
100Quick Access ToolbarAlt + 1, 2, 3...Run your custom toolbar buttons by number
Pro Tip — The 5 Shortcuts That Save the Most Time:
1. Ctrl + Arrow — stop scrolling through 10,000 rows
2. F4 — toggle $ signs without typing them
3. Ctrl + D — fill down without copy-paste
4. Alt + = — instant SUM
5. Ctrl + Shift + L — toggle filters in one keystroke
1. Ctrl + Arrow — stop scrolling through 10,000 rows
2. F4 — toggle $ signs without typing them
3. Ctrl + D — fill down without copy-paste
4. Alt + = — instant SUM
5. Ctrl + Shift + L — toggle filters in one keystroke
Interview Trick: When doing a timed Excel test, use Ctrl + End first to see where the data ends. Then Ctrl + Home to go back to start. This gives you a mental map of the dataset before you begin solving.
Hidden Gem — Alt + ; (Select Visible Cells Only): When you copy filtered data, Excel copies hidden rows too. Press Alt + ; before copying to select only visible cells. This prevents pasting hidden data into your report.
Practice Excel at Speed
The fastest way to internalize shortcuts is to practice under pressure. Verma Learning's question format — load, solve, submit — forces you to use shortcuts to keep up.
Download Free — vermalearning.com