MS Excel - Shortcutsby Gokul.
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 |
ESC | Cancel a cell entry |
BACKSPACE | Delete the character to the left of the insertion point, or delete 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 |
ENTER | Complete a cell entry |
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) |
|
CTRL+0 (zero) | Hide columns |
CTRL+SHIFT+) (closing parenthesis) |
|
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) |
|
CTRL+TAB or CTRL+SHIFT+TAB (when a toolbar is active) |
|
ENTER | |
SHIFT+F10 | Show a shortcut menu |
ALT+SPACEBAR | Show the program icon menu (on the program title bar) |
No comments:
Post a Comment