04 December 2013

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

No comments:

Post a Comment

About The Author

Signature

Signature