Switches to the next pane in a worksheet that has been split, the zoom controls, the open task pane, and the Ribbon. Switches to the previous pane in a worksheet that has been split, the Ribbon, the open task pane, and the zoom controls. Opens the Find and Replace dialog box to the Find tab (same as Ctrl+F). Opens the Go To dialog box (same as Ctrl+G). Repeats the last action performed, if possible (same as Ctrl+Y). Opens the Paste Name dialog box to paste a defined name into a formula. Saves the active workbook (same as Ctrl+S and Shift+F12). Shows or hides the Ribbon (double-clicking any Ribbon tab also shows or hides the Ribbon).Ĭreates a chart of the data in the current range (same as F11).Ĭreates a new worksheet (same as Shift+F11).Įnables editing of the contents of the selected cell (same as double-click).Īdds a comment or edit an existing comment. Undoes or redoes the last automatic correction when AutoCorrect Smart Tags are displayed. Undoes the last action performed (same as Alt+Backspace). Repeats the last action performed, if possible (same as F4). Pastes the clipboard contents (same as Shift+Insert).Ĭuts (copies to the clipboard and deletes) the selection (same as Shift+Del). Saves the active workbook (same as Shift+F12 and Alt+Shift+F2). Opens the Open dialog box to locate or specify a file to open.Ĭopies the contents and format of the rightmost selected cell in each row of the selected range into the other selected cells in the row. Opens the Insert Hyperlink dialog box when the cursor is not at a hyperlink or the Edit Hyperlink dialog box for a selected existing hyperlink. Toggles italic formatting (same as Ctrl+3). Opens the Find and Replace dialog box to the Replacement tab. Opens the Search and Replace dialog box to the Find tab (same as Shift+F5). Toggles bold formatting (same as Ctrl+2).Ĭopies the selection to the clipboard (same as Ctrl+Insert).Ĭopies the contents and format of the uppermost selected cell in each column of the selected range into the other selected cells in the column. If the insertion point is to the right of a function name in a formula, inserts the argument names and parentheses. If the insertion point is to the right of a function name in a formula, pressing Ctrl+A opens the Function Arguments dialog box. Pressing Ctrl+A a second time selects the entire worksheet. Selects the entire worksheet or the current data region (the rectangular region containing filled cells around the active cell). For more information about the shortcut keys available in Excel, see the Microsoft help topic Keyboard Shortcut in Excel. The following table lists the default shortcut keys (which are also called shortcut keys or key combinations) that are available in Excel.
0 kommentar(er)
