MICROSOFT EXCEL SHORTCUT KEYS

Share This Post

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
spot_img

Related Posts

Art and Literature of Middle Ages

Art during the Middle Ages was different based on...

Literature of Ancient India: Sanskrit Drama

The origin of Sanskrit drama is in obscurity; there...

The Bhakti Movement of the Medieval Age

The Bhakti Movement, one of the most remarkable features...

Saivism: Origin, Principles and Kinds

The origin of Saivism may be traced to, as...

Sikhism – An Introduction to Sikh Religion

Sikhism had its origin in the teachings of Guru...

The Gandhara Art

The Gandhara Art, justifying its name, is localized to...
- Advertisement -spot_img