At the beginning of the computer technology, the Function keys were really useful. Nowadays, these keys become less useful but some of them are still really important if you work daily with Excel.
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 |
| + + |
|
| + + |
|
|