- 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
I am Waleed Qureshi. Welcome to my personal website.this is a general website made for everyone from every country.Whoever you are,I hope you find many useful things here.Download Latest Softwares,Games and Mobile Apps.Watch Tutorials and Live TV Channels.Learn Tips & Tricks and Earnings Here.
04 December 2013
Microsoft Excel Shortcut Keys
Labels:
Tips & Tricks
:a
:b
:c
:d
:e
:f
:g
:h
:i
:j
:k
:l
:m
:n
:o
:p
:q
:r
:s
:t Add smileys to Blogger +
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment