✅ Excel Short Keys List

Neeche Excel ki sabse jyada use hone wali 100+ short keys diye gaye hain, jinka upyog karke aap apni data entry speed ko 10x tak badha sakte ho.:

1. Ctrl + N (Short Key)
   Use: – New Excel file open karne ke liye


2. Ctrl + O (Short Key)
   Use: – Pehli se saved file open karne ke liye


3. Ctrl + S (Short Key)
   Use: – File ko save karne ke liye


4. F12 (Short Key)
   Use: – Save As window open karne ke liye


5. Ctrl + P (Short Key)
   Use: – Print window kholne ke liye


6. Ctrl + C (Short Key)
   Use: – Data copy karne ke liye


7. Ctrl + X (Short Key)
   Use: – Data cut karne ke liye


8. Ctrl + V (Short Key)
   Use: – Data paste karne ke liye


9. Ctrl + Z (Short Key)
   Use: – Pichla action undo karne ke liye


10. Ctrl + Y (Short Key)
    Use: – Undo ki reverse action redo karne ke liye


11. Ctrl + A (Short Key)
    Use: – Poora data select karne ke liye


12. Ctrl + B (Short Key)
    Use: – Text ko bold banane ke liye


13. Ctrl + I (Short Key)
    Use: – Text italic karne ke liye


14. Ctrl + U (Short Key)
    Use: – Underline lagane ke liye


15. Ctrl + 1 (Short Key)
    Use: – Format Cells window open karne ke liye


16. Ctrl + 2 (Short Key)
    Use: – Bold on/off


17. Ctrl + 3 (Short Key)
    Use: – Italic on/off


18. Ctrl + 4 (Short Key)
    Use: – Underline on/off


19. Ctrl + 5 (Short Key)
    Use: – Strikethrough on/off


20. Ctrl + 6 (Short Key)
    Use: – Object hide/unhide


21. Ctrl + 9 (Short Key)
    Use: – Row hide karne ke liye


22. Ctrl + Shift + 9 (Short Key)
    Use: – Hidden rows unhide karne ke liye


23. Ctrl + 0 (Short Key)
    Use: – Column hide karne ke liye


24. Ctrl + Shift + 0 (Short Key)
    Use: – Column unhide karne ke liye


25. Ctrl + Shift + L (Short Key)
    Use: – Filter on/off karne ke liye


26. Ctrl + F (Short Key)
    Use: – Find karne ke liye


27. Ctrl + H (Short Key)
    Use: – Find & Replace ke liye


28. Ctrl + K (Short Key)
    Use: – Hyperlink insert karne ke liye


29. Ctrl + ; (Short Key)
    Use: – Aaj ki date insert karne ke liye


30. Ctrl + Shift + : (Short Key)
    Use: – Current time insert karne ke liye


31. Ctrl + Shift + "$" (Short Key)
    Use: – Currency format lagane ke liye


32. Ctrl + Shift + "%" (Short Key)
    Use: – Percentage format lagane ke liye


33. Ctrl + Shift + "#" (Short Key)
    Use: – Date format apply karne ke liye


34. Ctrl + Shift + "@" (Short Key)
    Use: – Time format apply karne ke liye


35. Ctrl + Shift + "!" (Short Key)
    Use: – Number format lagane ke liye


36. Ctrl + Shift + & (Short Key)
    Use: – Cell border lagane ke liye


37. Ctrl + Shift + _ (Short Key)
    Use: – Border hatane ke liye


38. Ctrl + Shift + + (Short Key)
    Use: – New row ya column add karne ke liye


39. Ctrl + - (Short Key)
    Use: – Row ya column delete karne ke liye


40. Ctrl + Shift + ↑ (Short Key)
    Use: – Data ke top tak select karne ke liye


41. Ctrl + Shift + ↓ (Short Key)
    Use: – Data ke end tak select karne ke liye


42. Ctrl + Arrow Keys (Short Key)
    Use: – Large data me fast move karne ke liye


43. Shift + Space (Short Key)
    Use: – Pura row select karne ke liye


44. Ctrl + Space (Short Key)
    Use: – Pura column select karne ke liye


45. Ctrl + Page Up (Short Key)
    Use: – Previous sheet me jaane ke liye


46. Ctrl + Page Down (Short Key)
    Use: – Next sheet me jaane ke liye


47. F4 (Short Key)
    Use: – Last action repeat karne ke liye


48. F2 (Short Key)
    Use: – Cell ko edit karne ke liye


49. F7 (Short Key)
    Use: – Spell check karne ke liye


50. F11 (Short Key)
    Use: – Selected data ka chart banane ke liye


51. Alt + = (Short Key)
    Use: – AutoSum lagane ke liye


52. Alt + Enter (Short Key)
    Use: – Same cell me new line dalne ke liye


53. Alt + H + O + I (Short Key)
    Use: – Column width auto adjust karne ke liye


54. Alt + H + A + C (Short Key)
    Use: – Text center align karne ke liye


55. Alt + H + H (Short Key)
    Use: – Cell color change karne ke liye


56. Alt + A + T (Short Key)
    Use: – Table create karne ke liye


57. Alt + A + M (Short Key)
    Use: – Duplicate data remove karne ke liye


58. Alt + A + Q (Short Key)
    Use: – Flash fill apply karne ke liye


59. Ctrl + T (Short Key)
    Use: – Table banane ke liye


60. Ctrl + D (Short Key)
    Use: – Data ko neeche fill karne ke liye


61. Ctrl + R (Short Key)
    Use: – Data ko right fill karne ke liye


62. Ctrl + ‘ (Short Key)
    Use: – Upar wale cell ka formula copy karne ke liye


63. Shift + F2 (Short Key)
    Use: – Cell comment add/edit karne ke liye


64. Shift + F10 (Short Key)
    Use: – Right-click menu open karne ke liye


65. Ctrl + Delete (Short Key)
    Use: – Active cell ka data delete karne ke liye


66. Ctrl + Shift + Space (Short Key)
    Use: – Poora worksheet select karne ke liye


67. Ctrl + Q (Short Key)
    Use: – Quick analysis tool open karne ke liye


68. Ctrl + Alt + V (Short Key)
    Use: – Paste Special ke liye


69. Alt + W + F (Short Key)
    Use: – Freeze Panes on karne ke liye


70. Ctrl + F2 (Short Key)
    Use: – Print preview dekhne ke liye


71. Ctrl + Shift + U (Short Key)
    Use: – Formula bar expand/close


72. Ctrl + Shift + "~" (Short Key)
    Use: – General format lagane ke liye


73. Ctrl + Shift + E (Short Key)
    Use: – Flash fill (Excel 365)


74. Ctrl + Shift + O (Short Key)
    Use: – Comments wale cells select karne ke liye


75. Ctrl + F3 (Short Key)
    Use: – Name manager open karne ke liye


76. Ctrl + Shift + F3 (Short Key)
    Use: – Names create karne ke liye


77. Ctrl + Alt + F5 (Short Key)
    Use: – Pivot table refresh karne ke liye


78. Ctrl + Tab (Short Key)
    Use: – Excel workbooks switch karne ke liye


79. Ctrl + Shift + Tab (Short Key)
    Use: – Backwards workbooks switch karne ke liye


80. Ctrl + Shift + L (Short Key)
    Use: – Filter apply/remove


81. Ctrl + Shift + “ (Short Key)
    Use: – Upar wala text copy karne ke liye


82. Ctrl + Shift + # (Short Key)
    Use: – Date format


83. Ctrl + Shift + $ (Short Key)
    Use: – Currency format


84. Ctrl + Shift + @ (Short Key)
    Use: – Time format


85. Ctrl + Shift + ! (Short Key)
    Use: – Number format


86. Ctrl + Alt + Shift + F9 (Short Key)
    Use: – Full calculation force


87. Ctrl + ` (Short Key)
    Use: – Formulas show karne ke liye


88. Ctrl + Shift + "~" (Short Key)
    Use: – General number format


89. Ctrl + 8 (Short Key)
    Use: – Outline symbols show/hide


90. Ctrl + Shift + K (Short Key)
    Use: – Custom style apply


91. Ctrl + Shift + S (Short Key)
    Use: – Theme change


92. Ctrl + Shift + C (Short Key)
    Use: – Format copy


93. Ctrl + Shift + V (Short Key)
    Use: – Format paste


94. Ctrl + Home (Short Key)
    Use: – Sheet ke starting cell par jana


95. Ctrl + End (Short Key)
    Use: – Sheet ke last cell par jana


96. Shift + Home (Short Key)
    Use: – Line ke start tak select karna


97. Shift + End (Short Key)
    Use: – Line ke end tak select karna


98. Ctrl + F4 (Short Key)
    Use: – Excel file close karne ke liye

Why Learn Excel Short Keys?

Excel mein kaam karte waqt short keys ka use karna bahut zaroori hota hai. Short keys ki madad se aap apne data entry work ko normal speed se 5x–10x tak fast bana sakte ho. Excel ek professional data management tool hai aur isme daily use ke liye kai tarah ke shortcuts diye gaye hain, jinka knowledge har beginner ya data entry operator ko hona chahiye. Short keys ka sabse bada fayda ye hota hai ki aap bina mouse use kiye sirf keyboard se Excel ko speed se control kar sakte ho. Isse time bachta hai, kaam fast hota hai aur accuracy bhi improve hoti hai. Chahe aap office work karte ho, school/college ka project banate ho ya online data entry job kar rahe ho — Excel shortcuts aapki productivity ko bahut badha dete hain. Isi wajah se hum yahan Excel ki 100+ Short Keys aur unka use simple language me bata rahe hain taaki aap easily samajh sako ki kaun si shortcut kis kaam ke liye use hoti hai

Excel Data Entry Tips

Excel data entry kaam ko fast, accurate और professional बनाता है. Agar aap Excel mein daily काम करते हैं to aapko basic shortcuts, formulas aur data clean करने की techniques का knowledge होना बहुत ज़रूरी है. Excel data entry sirf typing ka kaam नहीं है, बल्कि data ko sahi format mein arrange करना, गलती को चेक करना aur sheet ko readable banana bhi kaafi important hota hai.

Data entry ko आसान बनाने ke liye sabse pehle aapko Excel ke basic tools jaise AutoFill, Flash Fill, Sorting, Filtering, Data Validation, Remove Duplicates, Freeze Panes, और Basic Shortcuts ka use करना आना चाहिए. इन tools की मदद से आप कम समय में ज्यादा काम कर सकते हैं aur data mein गलती होने ke chances bhi kaafi कम हो जाते हैं.

Excel data entry ka सबसे बड़ा फायदा यह है कि यह आपकी productivity बढ़ाता है aur बड़े से बड़े data को भी आसानी से manage करने में मदद करता है. Aap jab Excel mein data enter करते hain to hamesha ध्यान रखें:

• Data ko clean format me rakhein.
• Same type ke data ko ek hi format me enter karein.
• Shortcuts ka upyog karein (jaise Ctrl + C, Ctrl + V, Ctrl + Z, Ctrl + S).
• Column headings ko clear aur meaningful rakhein.
• Spelling aur numbers ko double-check karein.
• Table format use karein taaki data zyada professional aur readable dikhe.

Agar aap in basic tips ko follow karte ho, तो Excel data entry बेहद आसान ho जाती है aur aapka काम तेज़ी se hota hai. Kisi bhi office job me Excel skills kaafi important hoti hain, isliye Excel data entry ke basics ko अच्छे se सीखना aapke career ke liye बहुत फायदेमंद साबित होगा.

← Back to Home