MICROSOFT EXCEL SHORTCUT KEYS

Microsoft-Excel
Here we have listed the different shortcut keys to operate Microsoft Excel Efficiently.Using this keys you can easily operate Microsoft Excel.
1. F2 : Edit the selected cell
2. F3 :  After a name has been created F3 will paste names
3. F5 :  Go to a specific cell. For example, C6
4. F7  :  Spell check selected text or document
5. F11  :  Create chart from selected data

6. Ctrl + Shift + ;  :  Enter the current time

7. Ctrl + ;  :  Enter the current date
8. Alt + Shift + F1  : Insert new worksheet
9. Shift + F3   :  Open the Excel formula window
10. Shift + F5  :  Bring up search box
11. Ctrl + A   :  Select all contents of the worksheet
12. Ctrl + B  :  Bold highlighted section
13. Ctrl + I  :  Italic highlighted section
14. Ctrl + K  :  Insert link
15. Ctrl + U   :  Underline highlighted section
16. Ctrl + 1   :  Change the format of selected cells
17. Ctrl + 5   :  Strike through highlighted section
18. Ctrl + P  :  Bring up the print dialogue box to begin printing
19. Ctrl + Z  Undo last action
20. Ctrl + F3  Open Excel Name Manager
21. Ctrl + F9   :  Minimize current window
22. Ctrl + F10  :  Maximize currently selected window
23. Ctrl + F6  :  Switch between open work books or windows
24. Ctrl + Page up  :  Move between Excel work sheets in the same Excel document
25. Ctrl + page down  :  Move between Excel worksheets in the same Excel document
26. Ctrl + Tab  :  Move between two or more open Excel document
27. Alt + =  :  Create a formula to sum all of the above cells
28. Ctrl + ’   :  Insert the value of the above cell into cell currently selected
29. Ctrl + Shift + !   :  Format number in comma format
30. Ctrl + Shift + $   :  Format number in currency format
31. Ctrl + Shift + #   :  Format number in date format
32. Ctrl + Shift + %   :  Format number in percentage format
33. Ctrl + Shift + ^   :  Format number in scientific format
34. Ctrl + Shift + @   :  Format number in time format
35. Ctrl + Arrow key   :  Move to the next selection on text
36. Ctrl + Space   :  Select entire column
37. Shift + Space   :  Select entire row
38. Ctrl + –   :  Delete the selected column or row
39. Ctrl + shift + =   :  Insert a new column or row
40. Ctrl + Home  :  Move to cell A1
41. Ctrl + ~   :  Switch between showing Excel formulas or their values in cells