Microsoft Excel Shortcut Keys

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.