Microsoft Excel Ke Shortcut Key Ki Puri Jankari


Aaj hum aapko microsoft excel ke shortcut key ki puri jankari dene wale hai.Agar aap computer / laptop user hai aur apne computer ya laptop par microsoft excel ka use karte hai,to aaj ki meri ye post excel shortcut key ke bare me aapke liye helpfull hogi.Q ki aap sab ko pata hai ki microsoft excel me bahut sare features hai aur bahut se log excel ka bahut hi achha use karte hai.Lekin aapko pata hona chahiye ki excel ka use karne me aapka bahut samay barbad hota hai,agar aap kam samay me excel par work karna chahte hai,to aap excel shortcut keys ki help se kar sakte hai.
Microsoft-Excel-Ke-Shortcut-Key


Aaj kal bahut se computer user microsoft excel ka use karte hai aur use excel ke shortcut key ke bare me pata nahi rahta hai.Jiski wajah se kisi bhi work ko complete karne me bahut hi jyada time lag jata hai.Lekin hum yaha aapko excel ke kuchh aise shortcut key ki jankari denge jisse aap excel par kisi bhi work ko bahut hi fast tarike se kar sakte hai.Aap sab ko pata hi hoga ki keyboard shortcuts keys kya hota hai aur keyboard shortcuts kise kahte hai.Keyboard shortcuts computer keyboard ka ek hissa hai,jisse hum computer par kisi bhi work ko bahut hi fast tarike se kar sakte hai.Keyboard shortcuts hame hamare kaam ko fast tarike se karne me hamara bahut madad karta hai.Isliye aaj phir hum aapke liye computer keyboard se related excel keboard shortcuts ko use karne ki jankari de rahe hai.Mujhe ummid hai ki aap is post ko rad karke excel ka master user ban sakte hai aur aap  excel ka bahut hi fast use kar sakte hai.To chaliye jante hai excel keyboard shortcuts ki details.

Excel Ke Keyboard Shortcut Keys

Mai aapko yaha par excel me use hone wale lagbhag sabhi keyboard shorts keys ke bare me bata raha hu.Aap in sabhi excel keyboard shorts ka use kar excel work ko bahut hi fast kar sakte hai.

1. F2 - Selected text ko edit kar sakte hai.

2. F3 - Name ko paste kar sakte hai.

3. F4 - Text ke colour ko old colour me replace kar sakte hai.

4. F5 - Specific cell par ja sakte hai.

5. F7 - Selected document and text ka spell check kar sakte hai.

6. F11 - Selected data se chart bana sakte hai.

7. Ctrl + Shift + ; - Current time enter kar sakte hai.

8. Ctrl + ; - Current date enter kar sakte hai.

9. Ctrl + 1 - Format cell windows open kar sakte hai.

10. Ctrl + A - Worksheet ke sabhi content ko select kar sakte hai.

11. Ctrl + B - Highlight selected ko bold kar sakte hai.

12. Ctrl + I - Highlight selectio ko italic kar sakte hai.

13. Ctrl + K - Link insert kar sakte hai.

14. Ctrl + S - Open worksheet ko save kar sakte hai.

15. Ctrl + U - Highlight selected ko underline kar sakte hai.

16. Ctrl + D - Fill down kar sakte hai.

17. Ctrl + R - Original cell ko bharne ke liye use kar sakte hai.

18. Ctrl + 5 - Strikethrough highlighted selection kar sakte hai.

19. Ctrl + P - Print windows open kar sakte hai.

20. Ctrl + Z - Last action ko undo kar sakte hai.


21. Ctrl + F3 - Excel name manager open kar sakte hai.

22. Ctrl + F9 - Current windows ko minimize kar sakte hai.

23. Ctrl + F10 - Currently selected windows ko maximize kar sakte hai.

24. Ctrl + F6 - Open workbooks or windows ko switch kar sakte hai.

25. Ctrl + Page Up - Ek h document me work sheets move kar sakte hai.

26. Ctrl + Page Down - Ek hi document me between work move kar sakte hai.

27. Ctrl + Tab - do ya do se adhik open excel file ke bich ja sakte hai.

28. Ctrl + ' - Selected cell se uprokt cell ke maan dalsakte hai.

29. Ctrl + Shift + 1 - Format number comma format me kar sakte hai.

30. Ctrl +Shift + 2 - Format number time format me kar sakte hai.

31. Ctrl + Shift + 3 - Format number date format kar sakte hai.

32. Ctrl + Shift + 4 - Format number currency format kar sakte hai.

33. Ctrl + Shift + 5 - Format number percentage format kar sakte hai.

34. Ctrl + Shift + 6 - Format number scientific format kar sakte hai.

35. Ctrl + Arrow key - Next section text me ja sakte hai.

36. Ctrl + Space - Full colum select kar sakte hai.

37. Ctrl + _ - Selected colum or row ko delete kar sakte hai.

38. Ctrl + Shift + = - New colum or row insert kar sakte hai.

39. Ctrl + Home - Home cell A1 me ja sakte hai.

40. Ctrl + ~ - Excel formula me switch kar sakte hai.


41. Alt + Shift + F1 - New worksheet insert kar sakte hai.

42. Alt + Enter - Cell me typing karte samay alt + enter dabakar next line ar ja sakte hai.

43. Alt + = - all sum ka yog ke liye formula bana sakte hai.

44. Shift + F3 - Excel formula windows open kar sakte hai.

45. Shift + F5 - Search box ko upar le ja sakte hai.

* Unix & Linux System Ke Shortcut Key

* Apple Macintosh Ke Kuchh Best Shortcut Keys

To friends aap in sabhi excel shortcut keys ka use kar sakte hai.Agar aap computer serelated shortcut key ki jankari chahte hai,to aap hamare computer label ke post ko read kar sakte hai.

If you like my post please comment here.Any problem,Ask me and share this post.

Previous
Next Post »
Thanks for your comment