Some Essential MS Excel shortcut

Today share some MS Excel function key shortcut

F1: Open a help task pane
F1+Ctrl: Opens or closes the help window
F2: To edit the text in the active cell
F2+Shift: To write a comment in the active cell
F2+Alt: Open the save as dialog box



F3+Shift: Open the insert dialog box
F3+Ctrl: Open the define name dialog box
F3+Shift+Ctrl: Open the create name dialog box

F4: To redo the last commend
F4+Ctrl: To close the workbook window
F4+Alt: To close the excel program

F5: Open the Goto dialog box
F5+Ctrl: Brings bcek to the first levle of workbook

F6: To shift between help taskbar and the excel window
F6+Shift: To go to the previous square in the open worksheet
F6+Ctrl: If more than workbook is open to switch between them

F7: To open spelling correction window
F7+Ctrl: When workbook window is not maximized it will move the window

F8: To activate/deactivate extended mode
F9: Will calculate all the worksheets in all open workbooks
F9+Shift: Will calculate the active worksheet
F9+Ctrl: To Minimize the workbook window
F10: Will select the menu bar
F10+Ctrl: To open minimized window

F11: Will create a chart using the current range
F11+Shift: To select a new worksheet
F11+Alt+Shift: Open Microsoft script editor

F12: Open save as dialog box
F12+Shift: Save the active worksheet
F12+Ctrl: To open the Open dialog box
F12+Ctrl+Shift: Open the Print dialog box