EXCEL SHORTCUTS BY PRO COMPUTER COURSE

एक्सेल में सुपरफास्ट बनने के ललए कीबोर्ड पे आपका हाथ अच्छी तरह से बैठना चाहहए है अब कीबोर्ड
पे हाथ बैठना याने शॉर्डकर् कीज़ पे अच्छी कमांर् होना और इसी के ललए ये है |

EXCEL KEYBOARD SHORTCUT KEYS PDF

1. Ctrl + E – Flash Fill

2. Ctrl+Page Up/Down: Move to the previous or next worksheet

3. Shift+Left/Right Arrow: Extend the cell selection to the left or right

4. Shift+Space: Select the entire row

5. Ctrl+Space: Select the entire column

6. Ctrl+Shift+Space: Select the entire worksheet

7. Home: Go to the leftmost cell in the current row (or go to the

beginning of the cell if editing a cell)

8. Ctrl+Home: Move to the beginning of a worksheet

9. Ctrl+End: Go to the most bottom right used cell

Page 1 of 11 https://procomputercourse.com
 EXCEL SHORTCUTS BY PRO COMPUTER COURSE

10. Page Up/Down: Move one screen up or down in a worksheet

11. Alt+Page Up/Down: Move one screen to the right or left in a

worksheet

12. F8 : Exntend Selection

13. Ctrl+W / CTRL + F4: Close a workbook (Alt + Space + C)

14. F4: Repeat the last command or action. For example, if the last
thing you typed in a cell is “hello,” or if you change the font color,
clicking another cell and pressing F4 repeats that action in the new
cell.

15. Shift+F11: Insert a new worksheet

16. Ctrl+Z: Undo an action

17. Ctrl+Y: Redo an action

18. Ctrl+N: Create a new workbook

19. Ctrl+O: Open an existing workbook

Page 2 of 11 https://procomputercourse.com
 EXCEL SHORTCUTS BY PRO COMPUTER COURSE

20. Ctrl+S: Save a workbook

21. F12: Open the Save As dialog box

22. Ctrl+ P: Print / Print Preview

23. F1: Open the Help pane

24. F7: Check spelling

25. F9: Calculate all worksheets in all open workbooks

26. Alt + V + Z : Zoom in / Zoom Out

27. Alt or F10: Turn key tips on or off

28. Ctrl+F1: Show or hide the ribbon

29. Ctrl+Shift+U: Expand or collapse the formula bar

30. Ctrl+F9: Minimize the workbook window

Page 3 of 11 https://procomputercourse.com
 EXCEL SHORTCUTS BY PRO COMPUTER COURSE

31. F11: Create a bar chart based on selected data (on a separate

sheet)

32. Alt+F1: Create an embedded bar chart based on select data (same

sheet)

33. Ctrl+F: Search in a spreadsheet, or use Find and Replace

34. Alt+F: Open the File tab menu

35. Alt+H: Go to the Home tab

36. Ctrl+Tab: Switch between open workbooks

37. Shift+F3: Insert a function

38. Alt+F8: Create, run, edit, or delete a macro

39. Alt+F11: Open the Microsoft Visual Basic For Applications Editor

Page 4 of 11 https://procomputercourse.com
 EXCEL SHORTCUTS BY PRO COMPUTER COURSE

40. Ctrl+Left/Right Arrow: Move to the farthest cell left or right in

the row

41. Ctrl+Up/Down Arrow: Move to the top or bottom cell in the

column

42. Tab = Goto the Next cell & Shift+Tab: Go to the previous cell

43. F5 or CTRL + G: Go to any cell by pressing F5 and typing the cell

44. F2: Edit a cell

45. Shift+F2: Add or edit a cell comment

46. Ctrl+X: Cut contents of a cell, selected data, or selected cell

47. Ctrl+C or Ctrl+Insert: Copy contents of a cell,

Page 5 of 11 https://procomputercourse.com
 EXCEL SHORTCUTS BY PRO COMPUTER COURSE

48. Ctrl+V or Shift+Insert: Paste contents of a cell, selected data, or

49. Ctrl+Alt+V: Open the Paste Special dialog box

50. Alt+Enter: Insert a hard return within a cell (while editing a cell)

51. F3: Paste a cell name (if cells are named in the worksheet)

52. Esc: Cancel an entry in a cell or the formula bar

53. Enter : Complete the Formula / Paste Content if already copied

54. Alt+H+H: Select a fill color

55. Alt+H+B: Add a border

56. Ctrl+Shift+&: Apply outline border

57. Ctrl+Shift+_ (Underscore): Remove outline border

58. Ctrl+9: Hide the selected rows

Page 6 of 11 https://procomputercourse.com
 EXCEL SHORTCUTS BY PRO COMPUTER COURSE

59. Ctrl + Shift + 9 : Unhide Rows

60. Ctrl+0: Hide the selected columns

61. Ctrl+1: Open the Format Cells dialog box

62. Ctrl+5: Apply or remove strike through

63. Ctrl+Shift+$: Apply currency format

64. Ctrl+Shift+%: Apply percent format

65. Ctrl+Shift+#: Apply Date format

66. Ctrl+Shift+@: Apply Time format

67. Ctrl+Shift+!: Apply Number format

68. Ctrl+Shift+ ~: Apply General format

69. Ctrl+ ‘ : Copy Above Content to Fill below

70. Ctrl + D = Fill Down

Page 7 of 11 https://procomputercourse.com
 EXCEL SHORTCUTS BY PRO COMPUTER COURSE

71. Ctrl + R – Fill Right

72. Ctrl + F3 = Name Manager

73. Ctrl + F10 = Restore Window or Alt + Space + R

74. Alt + Space + X – Maximize or Ctrl + F10 – Restore

75. Ctrl + F9 – Minimize / Alt + Tab – Maximize / Switch

76. Ctrl + F11 – Insert Macro Name Sheet

77. Ctrl + F12 = Open Dialog box

78. Ctrl + Shift + F1 – Hide Tab and Ribbon

79. Alt + V + U – Full Screen

80. Ctrl + Shift + F3 – Create Names from Selection

81. Alt + H + W – Wrap Text

Page 8 of 11 https://procomputercourse.com
 EXCEL SHORTCUTS BY PRO COMPUTER COURSE

82. Ctrl + Shift + Page Down / Page up – Select All Sheets to the right

/ Left

83. Ctrl + ; – Insert Date

84. Ctrl + Shift + ; – Insert Time

85. Ctrl + T – Create Table or Ctrl + L

86. Alt + H + O + R – Rename Sheet

87. Ctrl + H – Replace

88. Ctrl + K – Hyperlink

89. Ctrl + Shift + { – Select all cells which involved in selected

90. Ctrl + Shift + } – Select Formula cells where selected cell in

Page 9 of 11 https://procomputercourse.com
 EXCEL SHORTCUTS BY PRO COMPUTER COURSE

91. Ctrl + Shift + A – Insert Argument Names into a Formula

92. Alt + A + T – Apply and Remove Filter

93. ALT + N + V – PIVOT TABLE

94. ALT + = : AutotSum

95. ALT + H +M + C – MERGE AND CENTER

96. CTRL + ~ = Show and Hide All formulas from sheet

97. CTRL + SHIFT + ENTER – Create Array

98. Alt + A + Q – Advance Filter

99. Alt + H + O + I – Auto-fit Column Width

100. Alt + H + FP – Format Painter

101. Alt + H + E + F – Clear Format

102. Ctrl + + – Insert Column / Row

Page 10 of 11 https://procomputercourse.com
 EXCEL SHORTCUTS BY PRO COMPUTER COURSE

103. Ctrl + – = Delete Row / Column

104. Alt + I + R – Insert Row

105. Alt + I + C – Insert Column

……..The End………….

Learn Our Computer Courses in Offer

https://procomputercourse.com

https://mybigguide.com

Page 11 of 11 https://procomputercourse.com