Excel shortcuts

MS EXCEL 
Microsoft Excel is a spreadsheet developed by Microsoft for WINDOWS, MAC, Android and IOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications(VBA editor).

Download Link :Click Here
For Jobs related to Excel :Click Here

50 Essential shortcuts of Excel
1.How to create new workbook in Excel?
     Ctrl +n

2.How to open existing workbook in Excel?
     Ctrl+o

3.How to open print preview window?
    Ctrl+F2

4.How to close current workbook?
    Ctrl+F4

5.How to close excel?
    Alt+F4

6.How to expand or collapse a Ribbon?
   Ctrl+F1

7.How to activate access Keys?
     Alt

8.How to select a single column?
  Ctrl+Space

9.How to select a  single row?
   Shift+space

10.How to Undo last action?
   Ctrl+z

11.How to redo last action?
   Ctrl+y

12.How to repeat last action?
    F4

13.How to display,find and replace?
    Ctrl+H,Ctrl+F

14.How to find previous match?
    Ctrl+Shift+F4

15.How to find next match?
    Shift +F4

16.How to create embedded chart?
     Alt+F1

17.How to create table of excel sheet?
    Ctrl+T

18.How to Toggle Autofilter?
     Ctrl+Shift+L

20.How to Activate Filter?
   Alt+down arrow

21.How to insert a Table?
   Ctrl+T

22.How to move active cell clockwise in selection?
   Ctrl+.

23.How to move active cell up in selection?
    Shift+enter  or uparrow+enter

24.How to move active cell down in selection?
  downarrow+enter

25.How to extend selection by one cell right?
   Shift+right arrow

26.How to extend selection by one cell by left?
  Shift+left arrow

27.How to extend selection by one cell by up?
  Shift+up arrow

28.How to extend selection by one cell by down?
  Shift+down arrow

29.How to extend selection to last cell right?
  Ctrl+Shift+right arrow

30.How to extend selection to last cell left?

  Ctrl+Shift+left arrow

31.How to extend selection to last cell down?
  Ctrl+Shift+down arrow

32.How to extend selection to last cell up?
  Ctrl+Shift+up arrow

33.How to extend selection up one screen?
  Shift+pgup

34.How to extend selection up one screen?
  Shift+pgdn

35.How to get time in excel?
 Ctrl+:  or TODAY()

36 How to  time in excel?
  Ctrl+Shift+: or NOW()

37.How to make modification in a column which are divided by delimiters,split data in two columns?
  Alt+A+e

38.How to make data in proper format removing spaces  etc.....
  =TRIM()

39.How to hide and unhide columns?
Hide:Ctrl+0
Unhide:Alt+H+O+U+L

40.How to hide and unhide rows?
Hide:Ctrl+9
Unhide:Ctrl+Shift+9

41.How to sort a column?
Alt+A+S+A

42.How to mark a value is low or high?
 Alt+H+L+I 

43.How to create a filter?
Ctrl+Shift+L


44.How  to insert a column?
Alt+I+C

45.How to insert a Row?
Alt+I+R

46.How to  create a new sheet in excel?
  Shift+F11

47.How to close create workbook in excel?
Ctrl+F4

48.How to go to next worksheet?
Ctrl+pgDn

49.How to go to previous worksheet?
Ctrl+pgup

50.How to open a new workbook?
Ctrl+Tab

For more Excel interview Questions and Answers click here
Please visit us on  www.desistreets.com