मै विनय (Computer Expert)
आपका बहुत बहुत स्वागत है।
आज के इस पोस्ट में हमलोग MS Excel के Shortcut Keys के बारे में जानेंगे। जिससे MS Excel में कोई भी काम आसानी से कर सकते है।
1. Ctrl +N = Create a new workbook
2. Ctrl + O = Open an existing Workbook
3. Ctrl + W = Close a workbook
4. Ctrl + F4 = Close excel
5. Shift +F11 = Insert a new worksheet
6. Ctrl + F2 = Print Preview
7. Ctrl + F1 = Show or hide the ribbon
8. Ctrl + Shift + U = Expand or collapse the formula bar
9. Ctrl +F9 = Minize the workbook window
10. Alt + F = Open the file tab menu
11. Alt + H = Go to the home tab
12. Alt + N = Go the insert tab
13. Alt + P = Go to the page layout tab
14. Alt +M = Go to the Formulas tab
15. Alt + A = Go to the data tab
16. Alt + R = Go to the review tab
17. Alt + W = Go to the view tab
18. Shift +F3 = Insert a function
19. Alt + F8 = Create a macro
20. Alt +F11 = Open the microsoft visual basic
21. Left / Right Arrow = Move one cell to the left / right
22. Ctrl + Left/Right Arrow = Move to the farthest cell left or right in the row
23. Up/Down Arrow = Move one cell up or down
24. Ctrl + Up/Down Arrow = Move to the top or bottom cell in the column
25. Tab = Go to the next cell
26. Shift + Tab = Go to the previous cell
27. Ctrl + End = Go to the most bottom right used cell
28. Ctrl + Home = Go to the most top left used cell
29. F5 = Go to any cell
30. Page Up / Down = Move one screen up or down in a worksheet
31. Alt + Page Up/Down = Move one screen to the right or left in a worksheet
32. Ctrl + Page Up/Down = Move to the previous or next worksheet.
33. Shift + Left/Right Arrow = Select the cell section to the left/right
34. Shift + Space = select the entire row
35. Ctrl + Space = select the entire column
36. Ctrl + Shift + Space = Select the entire worksheet
37. F2 = Edit a cell
38. Shift + F2 = Add a comment
39. Alt +H + H = Select a fill color
40. Alt + H + B = Add a border
41. Ctrl + Shift + _ = Remove outline border
42. Ctrl + 1 = Format cell
43. Ctrl + 2 = Bold
44. Ctrl + 3 = Italic
45. Ctrl + 4 = Underline
46. Ctrl + 5 = Strikethrough
47. Ctrl + 9 = Hide the selected row
48. Ctrl + 0 = Hide the selected column
49. Ctrl + Shift + 9 = Unhide rows
50. Ctrl + Shift + 0 = Unhide Columns
51. Ctrl +Shift + $ = Apply currency format
52. Ctrl + Shift +% = Apply percent format
ALL COMPUTER PDF NOTES AVAILABLE IN HINDI & ENGLISH MEDIUM
-----------------------------------------------------------------------------------------------------------------------------
COMPUTER NOTES FOR TEACHERS AVAILABLE IN HINDI & ENGLISH MEDIUM
Dear Teachers ऐसा कंप्यूटर नोट्स जिसे आप पढ़कर बच्चों को आसानी से पढ़ा सकते हैं। यह नोट्स केवल कंप्यूटर इंस्टिट्यूट एवं टीचर्स के लिए हैं। इस नोट्स में आप अपना Watermark, Header / Footer और या Logo भी लगा सकते हैं। यदि आपको नोट्स खरीदने से रिलेटेड कोई भी problem आती है तो आप हमें Call या WhatsApp कर सकते हैं। Call / WhatsApp: +91 9650597419
-----------------------------------------------------------------------------------------------------------------------------
COMPUTER PDF NOTES IN ENGLISH
-----------------------------------------------------------------------------------------------------------------------------
COMPUTER PDF NOTES IN HINDI
-----------------------------------------------------------------------------------------------------------------------------
BASIC COMPUTER PDF NOTES IN ENGLISH
-----------------------------------------------------------------------------------------------------------------------------
BASIC COMPUTER PDF NOTES IN HINDI
-----------------------------------------------------------------------------------------------------------------------------
MS WORD PDF NOTES IN ENGLISH
-----------------------------------------------------------------------------------------------------------------------------
MS WORD PRACTICE ASSIGNMENT FILE
-----------------------------------------------------------------------------------------------------------------------------
MS WORD PDF NOTES IN HINDI
-----------------------------------------------------------------------------------------------------------------------------
MS EXCEL PDF NOTES IN ENGLISH
-----------------------------------------------------------------------------------------------------------------------------
MS EXCEL PDF NOTES IN HINDI
-----------------------------------------------------------------------------------------------------------------------------
MS EXCEL PRACTICE ASSIGNMENT FILE
-----------------------------------------------------------------------------------------------------------------------------
INTERNET PDF NOTES IN HINDI
-----------------------------------------------------------------------------------------------------------------------------
COMPUTER / LAPTOP REPAIRING NOTES IN HINDI
0 Comments