Ever wondered, how that one guy in the office preps up spreadsheets so quickly? He’s barely touched the mouse and he’s still zapping away through the lines of data, updating them in bulk.
Do you ever get that feeling, wish you too could display your prowess ?
Well look no further – below is the list of Excel Short-cuts. A list of key combinations and what they do.
Now You too can impress others around you !
KEY | ACTION |
ENTER | Complete a cell entry and move down in the selection |
ALT+ENTER | Start a new line in the same cell |
CTRL+ENTER | Fill the selected cell range with the current entry |
SHIFT+ENTER | Complete a cell entry and move up in the selection |
TAB | Complete a cell entry and move to the right in the selection |
SHIFT+TAB | Complete a cell entry and move to the left in the selection |
DELETE | Delete the character to the right of the insertion point, or delete the selection |
CTRL+DELETE | Delete text to the end of the line |
Arrow keys | Move one character up, down, left, or right |
HOME | Move to the beginning of the line |
F4 or CTRL+Y | Repeat the last action |
SHIFT+F2 | Edit a cell comment |
CTRL+SHIFT+F3 | Create names from row and column labels |
CTRL+D | Fill down |
CTRL+R | Fill to the right |
BACKSPACE | Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents |
CTRL+SHIFT+ENTER | Enter a formula as an array formula |
ESC | Cancel an entry in the cell or formula bar |
CTRL+A | Display the Formula Palette after you type a function name in a formula |
CTRL+SHIFT+A | Insert the argument names and parentheses for a function after you type a function name in a formula |
CTRL+K | Insert a hyperlink |
ENTER (in a cell with a hyperlink) | Activate a hyperlink |
F2 | Edit the active cell and position the insertion point at the end of the line |
F3 | Paste a defined name into a formula |
SHIFT+F3 | Paste a function into a formula |
F9 | Calculate all sheets in all open workbooks |
CTRL+ALT+F9 | Calculate all sheets in the active workbook |
SHIFT+F9 | Calculate the active worksheet |
= (equal sign) | Start a formula |
ALT+= (equal sign) | Insert the AutoSum formula |
CTRL+; (semicolon) | Enter the date |
CTRL+SHIFT+: (colon) | Enter the time |
CTRL+SHIFT+” (quotation mark) | Copy the value from the cell above the active cell into the cell or the formula bar |
CTRL+` (single left quotation mark) | Alternate between displaying cell values and displaying cell formulas |
CTRL+’ (apostrophe) | Copy a formula from the cell above the active cell into the cell or the formula bar |
ALT+DOWN ARROW | Display the AutoComplete list |
ALT+’ (apostrophe) | Display the Style dialog box |
CTRL+1 | Display the Format Cells dialog box |
CTRL+SHIFT+~ | Apply the General number format |
CTRL+SHIFT+$ | Apply the Currency format with two decimal places (negative numbers appear 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 indicate A.M. or P.M. |
CTRL+SHIFT+! | Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values |
CTRL+SHIFT+& | Apply the outline border |
CTRL+SHIFT+_ | Remove outline borders |
CTRL+B | Apply or remove bold formatting |
CTRL+I | Apply or remove italic formatting |
CTRL+U | Apply or remove an underline |
CTRL+5 | Apply or remove strikethrough formatting |
CTRL+9 | Hide rows |
CTRL+SHIFT+( (opening parenthesis) | Unhide rows |
CTRL+0 (zero) | Hide columns |
CTRL+SHIFT+) (closing parenthesis) | Unhide columns |
F10 or ALT | Make the menu bar active, or close a visible menu and submenu at the same time |
TAB or SHIFT+TAB (when a toolbar is active) | Select the next or previous button or menu on the toolbar |
CTRL+TAB or CTRL+SHIFT+TAB (when a toolbar is active) | Select the next or previous toolbar |
SHIFT+F10 | Show a shortcut menu |
ALT+SPACEBAR | Show the program icon menu (on the program title bar) |