MS EXCEL NOTES
by
Vinay Kumar Sah (Technical Superstar)
Wednesday, November 06, 2019
MS EXCEL SHORTCUT KEYS
नमस्कार दोस्तों !
मै विनय (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
मै विनय (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
Post a Comment
0 Comments