Microsoft Office Excel Shortcuts
Categories
|
|
Worksheet Shortcuts
Complete a cell entry and select the
cell below. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Enter] Start a new line in the same cell. . . . . . . .[Alt] + [Enter] Fill the selected cell range with the current entry. . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Enter] Complete a cell entry and select the previous cell above. . . . . . . . . . . . . . . . . . . . .[Shift] + [Enter] Complete a cell entry and select the next cell to the right. . . . . . . . . . . . . . . . . . .[Tab] Complete a cell entry and select the previous cell to the left. . . . . . . . . . . . . . . . .[Shift] + [Tab] Cancel a cell entry. . . . . . . . . . . . . . . . . . . . .[Esc] Move one character up, down, left, or right. Arrow Keys Move to the beginning of the line. . . . . . .[Home] Repeat the last action if possible. . . . . . . .[F4] or [Ctrl] + [Y] Fill down. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [D] Fill to the right. . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [R] Define a name. . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [F3] Insert a hyperlink. . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [K] Enter the date. . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [;] Enter the time. . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [:] Display a drop-down list of the values in the current column of a range. . . . . . . .[Alt] + [Down Arrow] Undo the last action. . . . . . . . . . . . . . . . . . .[Ctrl] + [Z] Start a formula. . . . . . . . . . . . . . . . . . . . . . . .[=] Move the insertion point into the Formula Bar when editing in a cell is turned off. . . . . . . . . . . . . . . . . . . . . . . . . . .[F2] In the Formula Bar, delete one character to the left. . . . . . . . . . . . . . . . . . . .[Backspace] Complete a cell entry from the cell or Formula Bar. . . . . . . . . . . . . . . . . . . . . . . . . . .[Enter] Cancel an entry in the cell or Formula Bar. . . . . . . . . . . . . . . . . . . . . . . . . . .[Esc] In a formula, display the Insert Function dialogue box. . . . . . . . . . . . . . . . .[Shift] + [F3] When the insertion point is to the right of a function name in a formula, display the Function Arguments dialogue box. . . . . . . . . . . . . . .[Ctrl] + [A] When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses. . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [A] Paste a defined name into a formula. (Name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) . . . .[F3] Insert an AutoSum formula with the SUM function. . . . . . . . . . . . . . . . . . . . . . . . .[Alt] + [=] Copy the value from the cell above the active cell into the cell or the Formula Bar. [Ctrl] + [Shift] + [“] Copies a formula from the cell above the active cell into the cell or the Formula Bar. [Ctrl] + [‘] Alternate between displaying cell values and displaying formulae. . . . . . . . . . . . . . . .[Ctrl] + [`] Calculate all worksheets in all open workbooks. When a portion of a formula is selected, calculate the selected portion. You can then press [Enter] or [Ctrl] + [Shift] + [Enter] (for array formulae) to replace the selected portion with the calculated value. . . . . . .[F9] |
Calculate the active worksheet. . . . . . . . . .[Shift] + [F9]
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. .[Ctrl] + [Alt] + [F9] Rechecks dependent formulae and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. . . . . . . . . . . . .[Ctrl] + [Alt] + [Shift] + [F9] Edit the active cell and position the insertion point at the end of the cell contents. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[F2] Start a new line in the same cell. . . . . . . .[Alt] + [Enter] Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents. . . . . .[Backspace] Delete the character to the right of the insertion point, or delete the selection. . .[Delete] Delete text to the end of the line. . . . . . . .[Ctrl] + [Delete] Display the Spelling dialogue box. . . . . . .[F7] Edit a cell comment. . . . . . . . . . . . . . . . . . . .[Shift] + [F2] Complete a cell entry and select the next cell below. . . . . . . . . . . . . . . . . . . . . . . .[Enter] Undo the last action. . . . . . . . . . . . . . . . . . .[Ctrl] + [Z] Cancel a cell entry. . . . . . . . . . . . . . . . . . . . .[Esc] When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction. . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Z] Copy the selected cells. . . . . . . . . . . . . . . . .[Ctrl] + [C] Cut the selected cells. . . . . . . . . . . . . . . . . . .[Ctrl] + [X] Paste copied cells. . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [V] Clear the contents of the selected cells. . .[Delete] Delete the selected cells. . . . . . . . . . . . . . . .[Ctrl] + [-] Insert blank cells. . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [+] Display the Style dialogue box. . . . . . . . . .[Alt] + [‘] Display the Format Cells dialogue box. . .[Ctrl] + [1] Apply the General number format. . . . . . .[Ctrl] + [Shift] + [~] Apply the Currency format with two decimal places (negative numbers in parentheses). . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [$] Apply the Percentage format with no decimal places. . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [%] Apply the Exponential number format with two decimal places. . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [^] Apply the Date format with the day, month, and year. . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [#] Apply the Time format with the hour and minute, and AM or PM. . . . . . . . . . . . .[Ctrl] + [Shift] + [@] Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. . . .[Ctrl] + [Shift] + [!] Apply or remove bold formatting. . . . . . . .[Ctrl] + [B] Apply or remove italic formatting. . . . . . .[Ctrl] + [I] Apply or remove underlining. . . . . . . . . . .[Ctrl] + [U] Apply or remove strikethrough. . . . . . . . . .[Ctrl] + [5] Hide the selected rows. . . . . . . . . . . . . . . . .[Ctrl] + [9] Hide the selected columns. . . . . . . . . . . . . .[Ctrl] + [0] Unhide any hidden rows within the selection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [(] Unhide any hidden columns within the selection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [)] Apply the outline border to selected cells. .[Ctrl] + [Shift] + [&] Remove the outline border from the selected cells. . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [_] Apply or remove the top border. . . . . . . . .[Alt] + [T] Apply or remove the bottom border. . . . . .[Alt] + [B] Apply or remove the left border. . . . . . . . .[Alt] + [L] Apply or remove the right border. . . . . . . .[Alt] + [R] If cells in multiple rows are selected, apply or remove the horizontal divider. .[Alt] + [H] If cells in multiple columns are selected, apply or remove the vertical divider. . . . .[Alt] + [V] Apply or remove the downward diagonal border. . . . . . . . . . . . . . . . . . . . . . . .[Alt] + [D]Apply or remove the upward diagonal border. . . . . . . . . . . . . . . . . . . . . . . .[Alt] + [U] |