Current Affairs

Function Keys of Microsoft Excel

Function Keys of Microsoft Excel

Function Keys కోసం చిత్ర ఫలితం

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.  

About the author

Mallikarjuna

Leave a Comment

error: Content is protected !!