Function Keys Usage in MS Excel 2007

Function Keys in MS Office, as the very name indicates, are used to perform number of functions in MS Office
. I this blog, we have tried to mention some of the functions which can be performed by using function keys alone or in combination with other keys.
Few of these combinations/ keys are very important and have been discussed in detail in table below.

Serial Number	Function Key Combination	Action
1	F1	Displays the Microsoft Office Excel Help task pane. In all MS office soft ware F1 is used to open Help task pane. This reminds of a joke that a drowning user of MS office was shouting F1, F1 to obtain help from someone :P
2	Alt + F1	This combination is used to create chart of the data in the current range.
3	Ctrl  + F1	I will not mention what function is performed when you press F2. Try it yourself as its interesting without any harm.
4	Alt + Shift + F1	A new worksheet can be inserted through this combination.
5	F2	F2 is used to edits the cell which is currently active. If editing in a cell is turned off, pressing F2 moves the insertion point into the Formula Bar.
6	Ctrl  + F2	This command pertains to printing options and related information. It displays the Print Preview window.
7	Shift + F2	It is used to add comment on a cell. If there is already a comment, this combination can be used to edit the comment.
8	F3	It displays the Paste Name dialog box.
9	Shift + F3	Opens the Insert Function dialog box.
10	Ctrl  + F3	It displays the Name Manager and also used to create new names.
11	F4	It is a very useful function key. It repeats the last command or action performed.
12	Ctrl  + F4	This combination is used to close the currently open workbook just like Ctrl + W.
13	F5	It opens the “Go To” dialog box.
14	Ctrl  + F5	This combination restores the window size of currently open workbook window.
15	F6	This is another important key. It can be used to switch between the worksheet, Ribbon, task pane, and zoom controls. In a worksheet which has been split any way e.g view menu, manage this window, freeze panes or split window command, F6 includes the split panes when switching between panes and the ribbon area.
16	Ctrl  + F6	This is a navigational key and can be used to switch to the next workbook window when more than one workbooks are open.
17	Shift + F6	It is used to switch between the worksheet, zoom controls, task pane, and ribbon.
18	F7	This is ideal key for proof reading. It displays the Spelling dialog box to check spelling in the active worksheet or selected range, if so selected.
19	Ctrl  + F7	It is another navigational key. It performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.
20	F8	It is used to turns “extend mode” on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
21	Ctrl  + F8	It performs the size command (on the Control menu for the workbook window) when a workbook is not maximized.
22	Alt + F8	This combination is used to open the “Macro” World. It Displays the Macro dialog box to create, run, edit, or delete a macro.
23	Shift + F8	This combination can be used to add a non adjacent cell or range to a selection of cells by using the arrow keys.
24	F9	It calculates all worksheets in all open workbooks.
25	Ctrl  + Alt + F9	It calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
26	Shift + F9	It calculates the active worksheet.
27	Ctrl  + F9	It minimizes the workbook window to bottom left of Excel window as an icon.
28	Ctrl  + Alt + Shift + F9	It can be used to rechecks dependent formulas, and then to calculate all cells in all open workbooks, including cells not marked as needing to be calculated.
29	F10	Used to turns “key tips” on or off.
30	Ctrl  + F10	This combination can be used to maximize or restore currently active workbook window.
31	Shift + F10	It works as “right click of your mouse” and displays the shortcut menu for currently active cell or cells, if so selected.
32	Alt + Shift + F10	It can be used to display the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.
33	F11	It creates a chart of the data in the current range.
34	Alt + F11	Opens the Microsoft Visual Basic Editor, in which you can create a “Macro” by using Visual Basic for Applications (VBA).
35	Shift + F11	Another important combination which is used to insert a new worksheet.
36	F12	This key opens the “Save As” dialog box to create copy of existing workbook.