Excel Keyboard Shortcut – Function Keys

The table below is the Microsoft Excel keyboard shortcut for the function keys from F1 to F12.

	Function key	+SHIFT	+CTRL	+ALT
F1	Displays the Help task pane		Closes and reopens the current task pane	Creates a chart of the data in the current range
F2	Edits the active cell and positions the insertion point at the end of the cell contents or Moves the insertion point into the Formula Bar when editing in a cell is turned off	Edits a cell comment		Opens the Save As dialog box
F3	Pastes a defined name into a formula	Opens the Insert Function dialog box	Opens the Define Name dialog box
F4	Repeats the last command or action		Closes the workbook window	Quits Microsoft Excel or Closes the active window or dialog box
F5	Displays the Go To dialog box		Restores the window size of the workbook window
F6	Switches between the Help task pane and the program window or Switches to the next pane in a worksheet that has been split	Switches to the previous pane in a worksheet that has been split	Switches to the next workbook window (when more than one window is open)	Moves from an open dialog box back to the document (some dialog boxes support this)
F7	Checks spelling		Moves the workbook window (when it isn’t maximized)
F8	Turns Extend mode on or off	Enables you to add a non-adjacent cell or range to a selection of cells by using the arrow keys	Resizes the workbook window (when it isn’t maximized)	Displays the Macros dialog box
F9	Calculates all worksheets in all open workbooks or Calculates the selected portion of a formula or Replaces the selected portion of a formula with the calculated value when followed by ENTER (CTRL+SHIFT+ENTER for array formulas)	Calculates the active worksheet	Minimizes the workbook window
F10	Selects the Menu Bar or Closes an open menu and submenu at the same time	Displays the Shortcut menu for the selected item or Displays a menu of commands for the Help window when the Help window has active focus	Maximizes or restores the window
F11	Creates a chart of the data in the current range	Inserts a new worksheet		Switches between the Visual Basic Editor and the previous active window
F12	Opens the Save As dialog box	Saves the active workbook	Opens the Open dialog box

	Enter your search termsSubmit search form
	Web www.msoffice-tutorial-training.com

You're viewing the Microsoft Excel keyboard shortcut info page, click here to go back to the Home Page