Friday, July 12, 2013

Shortcut function keys in excel

The following lists contain CTRL combination shortcut keys, function keys, and some other common shortcut keys, along with descriptions of their functionality.



Detail 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 
That's all. You can use these keys to get work faster.