Top 35 Essential Excel Keyboard Shortcuts & Productivity Hacks for Office Jobs
Excel Shortcuts Keno Jantei Hobe?
Ekjon general computer user ebong ekjon Excel expert-er modhe prodhan parthokko holo keyboard shortcuts ebong mouse-free speed. Job interview ba desk work-e apni koto druto report toiri korte paren tar upor depend kore apnar efficiency.
1. Super Fast Data Navigation Shortcuts
Ctrl + Arrow Keys:Data table-er ekebare seshe (Last cell with data) jump korar jonno.Ctrl + Shift + Arrow:Puro row ba column er data ek clike select kora.Ctrl + Home:Ekebare sheet-er prothom cellA1-e phire jawa.Ctrl + End:Sheet-er last active cell-e jawa.Ctrl + PageDown / PageUp:Next ba previous worksheet tab-e switch kora.
2. Data Entry & Editing Super-Hacks
| Shortcut | Action | Use Case |
|---|---|---|
| Ctrl + E | Flash Fill | First Name & Last Name alada kora ba format thik kora bina formulay! |
| Ctrl + D | Fill Down | Uporer cell-er data ba formula niche copy kora. |
| Ctrl + R | Fill Right | Bamer cell-er content daan-dike copy kora. |
| Alt + = | AutoSum | Instant SUM formula generate kora. |
| Ctrl + Shift + L | Toggle Filter | Table-e Instant AutoFilter On/Off kora. |
| F4 | Lock Reference / Repeat | Cell reference lock ($A$1) kora ba last action repeat kora. |
3. Formatting & Cell Dialogs
Ctrl + 1:Format Cells dialog box open kora (Custom number format, borders, fill).Ctrl + Shift + ~:General number format apply kora.Ctrl + Shift + $:Currency format (₹/$) apply kora.Ctrl + Shift + %:Percentage format apply kora.Ctrl + Shift + #:Date format (DD-MMM-YY) apply kora.Ctrl + ` (Backquote):Sheet-er shob cell-e formula show/hide kora (Audit mode).
4. Top Productivity Features You Must Use
Flash Fill (Ctrl + E): Jodi apnar kache 500 joner full name thake (e.g. "Satyajit Giri"), apnar sudhu prothom cell-e "Satyajit" type kore Ctrl + E press korte hobe — baki 499 joner First Name second-e fill hoye jabe!
Transpose: Row-er data-ke Column-e ba Column-er data-ke Row-te convert korte Copy korun -> Alt + E + S + E (Paste Special Transpose).
Official Course Study Notes & Practice Materials
Pragati Skill Academy provides complete chapter-by-chapter curriculum notes, 195+ solved MCQs, formula cheat sheets, and practical lab assignments with recognized government certifications.