100+ MS EXCEL WINDOWS SHORTCUT KEYS

100+ MS EXCEL WINDOWS SHORTCUT KEYS

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 

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 : Extend 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 

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

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 

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 coordinate or cell name. 

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 range 

47) Ctrl + C or Ctrl + Insert: Copy contents of a cell, selected data, or selected cell range 

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

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 

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

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 

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 formula

90) Ctrl + Shift + } - Select Formula cells where selected cell in included

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 + = AutoSum 

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 + F + P - Format Painter 

101) Alt + H + E + F - Clear Format 

102) Ctrl + + - Insert Column / Row 

103) Ctrl + - = Delete Row / Column 

104) Alt + I + R - Insert Row 

105) Alt + I + C - Insert Column