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

 In this Excel Tip and Trick we take a look at how we can use Excel Shortcuts to accomplish some of the key functionality of Excel without using a mouse.
  • 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

 

Keyboard shortcuts

 

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.