Function Keys of Microsoft Excel

Function Keys of Microsoft Excel

Function Key ( F1 )

• Displays the Help task pane.   
• CTRL+F1 closes and reopens the current task pane.   
• ALT+F1 creates a chart of the data in the current range.   
• ALT+SHIFT+F1 inserts a new worksheet.

Function Key ( F2 )

• Edits the active cell and positions the insertion point at the end of the cell contents. 
• It also moves the insertion point into the Formula Bar when editing in a cell is turned off.   
• SHIFT+F2 edits a cell comment.

Function Key ( F3 )

• Pastes a defined name into a formula.   
• SHIFT+F3 displays the insert Function dialog box.

Function Key ( F4 )

• Repeats the last command or action, if possible.   
• CTRL+F4 closes the selected workbook window.

Function Key ( F5 )

• Displays the Go To dialog box.   
• CTRL+F5 restores the window size of the selected workbook window.

Function Key ( ARROW KEYS )

• Move one cell up, down, left, or right in a worksheet.   
• CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or data sheet borders.) in a worksheet.   
• SHIFT+ARROW KEY extends the selection of cells by one cell.   
• CTRL+SHIFT+ARROW KEY extends the selection of cells to the last non blank cell in the same column or row as the active cell.   
• LEFT ARROW or RIGHT ARROW selects the menu to the left or right when a menu is visible. When a sub menu is open, these arrow keys switch between the main menu and the sub menu.   
• DOWN ARROW or UP ARROW selects the next or previous command when a menu or sub menu is open.   
• In a dialog box, arrow keys move between options in an open drops down list, or between options in a group of options.   
• ALT+DOWN ARROW opens a selected drops down list.

Function Key ( F6 )

• Switches to the next pane in a worksheet that has been split (Window menu, Split command).   
• SHIFT+F6 switches to the previous pane in a worksheet that has been split.   
• CTRL+F6 switches to the next workbook window when more than one workbook window is open.   
• Note When the task pane is visible, F6 and SHIFT+F6 include that pane when switching between panes.

Function Key ( F7 )

• Displays the Spelling dialog box to check spelling in the active worksheet or selected range.   
• CTRL+F7 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 ESC.

Function Key ( F8 )

• Turns extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection.   
• SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.   
• CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.   
• ALT+F8 displays the Macro dialog box to run, edit, or delete a macro.

Function Key ( F9 )

• Calculates all worksheets in all open workbooks.   
• F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected a portion of a formula and replaces the selected portion with the calculated value.   
• SHIFT+F9 calculates the active worksheet.   
• CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.   
• CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.   
• CTRL+F9 minimizes a workbook window to an icon.

Function Key ( F10 )

• Selects the menu bar or closes an open menu and sub menu at the same time.   
• SHIFT+F10 displays the shortcut menu for a selected item.   
• ALT+SHIFT+F10 displays 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.   
• CTRL+F10 maximizes or restores the selected workbook window.

Function Key ( F11 )

• Creates a chart of the data in the current range.   
• SHIFT+F11 inserts a new worksheet.   
• ALT+F11 opens the Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).   
• ALT+SHIFT+F11 opens the Microsoft Script Editor, where you can add text, edit HTML tags, and modify any script code.

Function Key ( F12 )

• Displays the Save As dialog box.