Microsoft Excel is a very powerful application for spreadsheet. it is a best way for managing the efficient organized information. many keyboard shortcuts will absolutely suffice for everyday work. , it can be difficult to and become more productive without understanding a few tips and tricks or investing in professional education .The focus is on improving your productivity and making your day better.
Mouse shortcut keys
- Double-click (on a cell) -Edit the cell contents
- Double-click (on a row/column divider) – Adjust height/width to auto-fit
- High-light headers of multiple rows/columns then Double-click on a row/column divider- Adjust height/width to auto-fit of all high-lighted rows/columns
- Triple-click – Select the entire contents in the cell
- Click on row/column divider then drag – Adjust height/width of the row/column
- High-light headers of multiple rows/columns then Click on row/column divider then drag – Adjust height/width of the rows/columns
- Ctrl + Mouse wheel – Zooms in and out of document.
- Hold Shift + Click the cells – Select multiple cells
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.
They just make working with MS Excel easier, faster, and more accurate. It makes learning keyboard shortcuts simple and fun by suggesting useful shortcuts in a small notification window based on your mouse clicks and movements.