Microsoft Excel shortcuts

  Many professional students and staff uses the Microsoft excel for their work. Microsoft Excel makes their work easy and fast and easy to understand in aportable way. It is used by the number of people in this world. Microsoft Excel uses the table to collecting the data and mange these data. It will be easy when the people who uses the Excel know its shortcuts.

Many useful shortcuts are given below. They are described with their functions.

1. 
   

F5	Go to a specific excel cell
F11	Create the chart
F2	Edit selected cell
F7	Spell check for selected text
Ctrl+;	Enter current date.
Ctrl+Shift;	Enter current time.
Shift +F3	Open the formula window.
Shift +F5	BringUp search box.
Alt +Shift+F1	New worksheet insertion.
Ctrl +Page down	Move between Excel worksheets.
Ctrl +page up	Move between Excel worksheets.
Alt+=	Create formula for sum all above cells
Ctrl+tab	Move beteen two Open Excel files.
Ctrl +’	Insert the value of above cell into currently selected cell
Ctrl +shift +$	Format number in Currency format
Ctrl +shift +!	Format number in comma format
Ctrl +shift +#	Format numbers in date format
Ctrl +shift +@	Format number in time format
Ctrl +shift +^	Format number in scientific formats
Ctrl +shift +%	Format in percentage format
Shift +space	Entire row selection
Ctrl+space	Entire column selection
Ctrl +F6	Switch between open windows/workbooks.
Ctrl +f10	Maximize selected window
Ctrl +f9	Minimize current selected window
Ctrl +5	Strike through highlighted portion
Ctrl +P	Open print dialog box
Ctrl +z	Undo last action
Ctrl+B	Bold selected text
Ctrl+A	Select all contents
Ctrl +I	Italic selected text.
Ctrl+k	Insert link.
Ctrl +U	Underline selected portion.

Here is a list of shortcut keys in Microsoft Excel.

1. F1: Opens a help task pane
2. F1 + Ctrl: Opens or closes the help window
3. F2: To edit the text in the active cell
4. F2 + Shift: To write a comment in the active cell
5. F2 + Alt: Opens the save as dialog box
6. F3 + Shift: opens the insert dialog box
7. F3 + Ctrl: Opens the define name dialog box
8. F3 + Shift + Ctrl:  Opens the create name dialog box
9. F4:  To redo the last command
10. F4 + Ctrl: To close the workbook window
11. F4 + Alt: To close the excel program
12. F5: Opens the Goto dialog box
13. F5 + Ctrl: brings back to the first level of workbook
14. F6: To shift between help taskbar and the excel window
15. F6 + Shift: To goto the previous square in the open worksheet
16. F6 + Ctrl: If more than one workbook is open to switch between them
17. F7: To open spelling correction window
18. F7 + Ctrl: When workbook window is not maximised it will move the window
19. F8: To activate / deactivate extended mode
20. F9: Will calculate all the worksheets in all open workbooks
21. F9 + Shift: Will calculate the active worksheet
22. F9 + Ctrl: To Minimise the workbook window
23. F10: Will select the menu bar
24. F10 + Ctrl: To open minimised window
25. F11: Will create a chart using the current range
26. F11 + Shift: To select a new worksheet
27. F11 + Alt: To switch between visual basic editor and the worksheet
28. F11 + Alt + Shift: Opens microsoft script editor
29. F12: Opens save as dialog box
30. F12 + Shift: Saves the active workbook
31. F12 + Ctrl: To open the Open dialog box
32. F12 + Ctrl + Shift: Opens the print dialog box