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


Get FREE ebooks!
(Click for more info)

Subscribe to...
MS Office Tips Newsletter

E-mail Address:
First Name:
Then

Don't worry -- your e-mail address is totally secure.
I promise to use it only to send you MS Office Tips.

Can't find what you're looking for? Try Google Search!

Google
 

Back to Top

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