100+ Shortcuts use full in excel

 

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)