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)
