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..!! .........
Posted on: Mon, 20 Jan 2014 03:18:50 +0000
Trending Topics
Recently Viewed Topics
© 2015