#1 Microsoft Excel shortcut Keys

Microsft Excel Shortcut Keys:-

1. Ctrl+N:- Open a New Window.

2. Ctrl+A:- Select content in the worksheet.

3. Ctrl+B:- Bold highlighted Selection.

4. Ctrl+I:- Italic highlighted Selection.

5. Ctrl+K:- Open the Insert hyperlink dialogue.

6. Ctrl+P:- Bring up the print dialogue box.

7. Ctrl+U:- Underline highlighted Selection.

8. Ctrl+Page up:- Move to the previous sheet in a workbook.

9. Ctrl+Page Down:- Move to the next sheet in a workbook.

10. Ctrl+Tab:- Switch to the next tab in a dialogue box.

11. Ctrl+F9:- Minimize a workbook window to an icon.

12. Ctrl+F10:- Maximize a selected workbook window.

13. Ctrl+F6:- Switch to the next workbook window when multiple are open.

14. F2:- Edit the active cell.

15. F5:- Display the Go to a box.

16. F7:- Open the spelling dialogue box to check a selected page.

17. F11:- Create a chart of data in the current range in a separate sheet.

18. Alt+Shift+F1:- Insert a new worksheet.

19. Shift+F3:- Open Insert Function dialogue box.

20. Shift+F5:– Open the find and replace dialogue box.

21. Ctrl+Shift+colon(:):- Enter the current time.

22. Ctrl+Semicolon(;):- Enter the current date.

23. Shift+Space:- Select an entire row in a worksheet.

24. Ctrl+Space:- Select an entire column in a worksheet.

25. Ctrl+Arrowkeys:- Move to the edge of the current data region in a worksheet.

26. Ctrl+Shift+@:- Apply the time format.

27. Ctrl+Shift+^:- Apply the exponential format.

28. Ctrl+Shift+%:- Apply the percentage format.

29. Ctrl+Shift+#:- Apply the date format.

30. Ctrl+Shift+$:- Apply the currency format.

31. Ctrl+Shift+!:- Apply the Number format.

32.Ctrl+Apostrohe(‘):- Insert the value of the above cell into the cell currently selected.