Shortcut of key of excel list

It is 37 general program Shortcuts of MS office.

let’s take a look it at some general keyboard shortcuts for handling workbooks, feat help, and a few other boundary associated activities.

 

1. CTRL+S:-  we can Save a workbook.

2. Ctrl+O:- it is Open an existing workbook.

3. Ctrl+N:- We can Create a new workbook.

4. F12:- it is Open the Save As dialog box.

5. Ctrl+W:- we can Close a workbook.

6. CTRL+F4:- we and Close Excel application.

7. F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.

8. SHIFT+F11:- It’s insert a new worksheet.

9. CTRL+Z:- We can Undo an action.

10. CTRL+Y:- We could Redo an action.

11. CTRL+F2:- It can be Switch to Print Preview.

12. F1:- It is open the Help pane.

13. ALT+Q:-It is go to the “Tell me what you want to do” box.

14. F7:- we could Check spelling and.

15. F9:- It is calculate all worksheets in all open workbooks.

16. SHIFT+F9:-It is  calculate active worksheets.

17. ALT OR F10:- It is turn key tips on or off.

18. CTRL+F1:- It is Show or hide the ribbon.

19. CTRL+SHIFT+U:- It’s expand or collapse the formula bar.

20. CTRL+F9:- It is minimize the workbook window.

21. F11:- It’s create a bar chart based on selected data (on a separate sheet).

22. ALT+F1:- It is create an embedded bar chart based on select data (same sheet).

23. CTRL+F:- It is search in a spreadsheet, or use Find and Replace

24. ALT+F:- It is open the File tab menu.

25. ALT+H:- It is go to the Home tab.

26. ALT+N:- It is open the Insert tab.

27. ALT+P:- It is go to the Page Layout tab.

28. ALT+M:-  It is go to the Formulas tab.

29. ALT+A:- It is go to the Data tab.

30. ALT+R:- It is go to the Review tab.

31. ALT+W:- It is go to the View tab.

32. ALT+X:- It is go to the Add-ins tab.

33. ALT+Y:-  It is go to the Help tab.

34. CTRL+TAB:-It is switch between open workbooks.

35. SHIFT+F3:-  It is insert a function.

36. ALT+F8:- It is create, run, edit, or delete a macro.

37. ALT+F11:- It is open the Microsoft Visual Basic For Applications Editor.