Shorcuts – Function Key

Discover all the shortcuts with the Function Key

Function keys alone

 Help Toogle to the Edit mode Paste name formula (if you have defined Name in your worksheet) Toogle the reference of a cell (block/un-block) Goto Go to the next pane. Spell Check Extend Selection (EXT appears in the status bar). In Extend Mode, when you move the active cell (with the mouse or the arrow), you select all the cells. Calculate the entire workbook (all the worksheets) When you select a part of a formula, F9 convert the selection in result Activate Menu Add a chart Open the dialog box Save as ...

Function Keys + Shift

 + What's this help + Add a comment + Insert the sign = and display the dialog box Function + Find next + Find + Return to the previous Pane + + Toogle to the Mode ADD (you can see this information in the status bar). When you are in the Mode ADD, each clic select the cell WITHOUT unselected the previous one. + Calculate the active worksheet + Display the contextual menu + Insert a new worksheet + Open the dialog box Save as ...

Function Keys + Ctrl

 + Hide / Display the Ribbon + Toogle to the View before Print + Define name + Close the active workbook + Restore Windows size + Toogle to the next workbook + Move a minimize window with the arrow + Resize a reduce window with the arrow + Minimize the active workbook + Restore workbook + Insert a Macro Excel 4 + Open the dialog box Open a workbook

Function keys + Alt

 + Insert a new chart + Display the dialog box Save As ... + + Quit Excel + + + + Display the Macro list + + Open the pane of the Object Selection + Open the Visual Basic Editor +

Shortcuts with Shift & Ctrl

 + + + + + + Names from labels + + Select each empty cells (one by one) from the active cell till the cell A1 + + + + Go to the previous Workbook + + + + + + + + First, active the Ribbon. Second, display the parameter of the Ribbon + + + + Open the Print menu

Shortcuts with Shift & Alt

 + + Insert a new worksheet + + Open the dialog box Save As ... + + + + Close the active workbook + + + + + + + + + + + + + + + +