Saturday 4 April 2015

MICROSOFT EXCEL SHORTCUT KEYS

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