EXCEL SHORTCUT KEYS
1. F2 - Edit the selected cell
2. F5 - Go to a specific cell
3. F7 - Spell check selected text and/or document
4. F11 - Create chart
5. Ctrl + Shift + ; - Enter the current time
6. Ctrl + ; - Enter the current date
7. Alt + Shift + F1 - Insert new worksheet
8. Shift + F3 - Open the Excel® formula window
9. Shift + F5 - Bring up search box
10. Ctrl + A - Select all contents of worksheet
11. Ctrl + B - Bold highlighted selection
12. Ctrl + I - Italicize highlighted selection
13. Ctrl + C - Copy selected text
14. Ctrl + V - Paste
15. Ctrl + D - Fill
16. Ctrl + K - Insert link
17. Ctrl + F - Open find and replace options
18. Ctrl + G - Open go-to options
19. Ctrl + H - Open find and replace options
20. Ctrl + U - Underline highlighted selection
21. Ctrl + Y - Underline selected text
22. Ctrl + 5 - Strikethrough highlighted selection
23. Ctrl + O - Open options
24. Ctrl + N - Open new document
25. Ctrl + P - Open print dialog box
26. Ctrl + S - Save
27. Ctrl + Z - Undo last action
28. Ctrl + F9 - Minimize current window
29. Ctrl + F10 - Maximize currently selected window
30. Ctrl + F6 - Switch between open workbooks/windows
31. Ctrl + Page up & Page Down - Move between Excel worksheets in the same document
32. Ctrl + Tab - Move between two or more open Excel files
33. Alt + = - Create formula to sum all of above cells
34. Ctrl + ‘ - Insert value of above cell into current cell
35. Ctrl + Shift + ! - Format number in comma format
36. Ctrl + Shift + $ - Format number in currency format
37. Ctrl + Shift + # - Format number in date format
38. Ctrl + Shift + % - Format number in percentage format
39. Ctrl + Shift + ^ - Format number in scientific format
40. Ctrl + Shift + @ - Format number in time format
41. Ctrl + g - Move to next section of text
42. Ctrl + Space - Select entire column
43. Shift + Space - Select entire row
44. Ctrl + W - Close document
Post a Comment
if you have any problem please let me know