Shortcut function keys in excel

Here is a list of shortcut keys in Microsoft Excel.

F1: Opens 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: Opens the save as dialog box
F3 + Shift: opens the insert dialog box
F3 + Ctrl: Opens the define name dialog box

F3 + Shift + Ctrl:  Opens the create name dialog box
F4:  To redo the last command
F4 + Ctrl: To close the workbook window
F4 + Alt: To close the excel program
F5: Opens the Goto dialog box
F5 + Ctrl: brings back to the first level of workbook
F6: To shift between help taskbar and the excel window
F6 + Shift: To goto the previous square in the open worksheet
F6 + Ctrl: If more than one workbook is open to switch between them
F7: To open spelling correction window
F7 + Ctrl: When workbook window is not maximised 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 Minimise the workbook window
F10: Will select the menu bar
F10 + Ctrl: To open minimised window
F11: Will create a chart using the current range
F11 + Shift: To select a new worksheet
F11 + Alt: To switch between visual basic editor and the worksheet
F11 + Alt + Shift: Opens microsoft script editor
F12: Opens save as dialog box
F12 + Shift: Saves the active workbook
F12 + Ctrl: To open the Open dialog box
F12 + Ctrl + Shift: Opens the print dialog box

Kindly Bookmark this Post using your favorite Bookmarking service:

Do you Like this Article..?

Get Subscribe to Free Email Updates!!

*Your email address will not be shared with anyone.

Link To This Page:
<a href="https://7terabyte.blogspot.com/2011/11/shortcut-function-keys-in-excel.html" rel="follow" target="_blank">Shortcut function keys in excel</a>

Link To Home Page:
<a href="https://7terabyte.blogspot.com/" rel="follow" target="_blank">7TeraByte</a>