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.
