Loading...

Welcome to StudyVen

Ctrl+F9 : Minimizes a workbook window to an icon.
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.
Alt+F8 : Displays the Macro dialog to create, run, edit, or delete a macro.
F9 : Calculates all worksheets in all open workbooks.
Shift+F8 : Enables you to add a non-adjacent cell or range to a selection of cells by using the arrow keys.
Ctrl+F8 : Performs the Size command when a workbook is not maximized.
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 Enter, or Esc to cancel.
F8 : Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
Ctrl+Shift+F6 : Switches between all Excel windows.
F7 : Opens the Spelling dialog to check spelling in the active worksheet or selected range.
Shift+F6 : Switches between the worksheet, Zoom controls, task pane, and ribbon.
Ctrl+F6 : Switches between 2 Excel windows.
F6 : Switches between the worksheet, ribbon, task pane, and Zoom controls. In a worksheet that has been split , F6 includes the split panes when switching between panes and the ribbon area.
F5 : F5 alone: displays the Go To dialog.
Ctrl+F5 : Restores the window size of the selected workbook window.
Ctrl+F4 : Closes the selected workbook window.
Alt+F4 : Closes Excel
Shift+F3 : Displays the Insert Function dialog.
F4 : F4 alone: repeats the last command or action, if possible.
Ctrl+F2 : Displays the print preview area on the Print tab in the Backstage view.
F3 : Displays the Paste Name dialog. Available only if names have been defined in the workbook.
F2 : Edits the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference.
Shift+F2 : Adds or Edits a cell note.
Alt+F1 : Creates an embedded chart of the data in the current range.
Alt+Shift+F1 : Inserts a new worksheet.
F1 : Displays the Excel Help task pane.
Ctrl+F1 : Displays or hides the ribbon.
Open the task pane options menu. : Ctrl+Spacebar
Close the task pane. : Ctrl+Spacebar, then select Close