Tip & How-To about Computers & Internet
Here's what you are looking for. Browse it and you can find it there all you want for shortcut keys. Follow this link below:
Microsoft Excel Shortcut keys
Enter data by using shortcut keysToPress
Complete a cell entryENTERCancel a cell entryESCRepeat the last actionF4 or CTRL+YStart a new line in the same cellALT+ENTERDelete the character to the left of the insertion point, or delete the selectionBACKSPACEDelete the character to the right of the insertion point, or delete the selectionDELETEDelete text to the end of the lineCTRL+DELETEMove one character up, down, left, or rightArrow keysMove to the beginning of the lineHOMEEdit a cell commentSHIFT+F2Create names from row and column labelsCTRL+SHIFT+F3Fill downCTRL+DFill to the rightCTRL+RFill the selected cell range with the current entryCTRL+ENTERComplete a cell entry and move down in the selectionENTERComplete a cell entry and move up in the selectionSHIFT+ENTERComplete a cell entry and move to the right in the selectionTABComplete a cell entry and move to the left in the selectionSHIFT+TABWork in cells or the formula bar by using shortcut keysToPressStart a formula= (EQUAL SIGN)Cancel an entry in the cell or formula barESCEdit the active cellF2Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contentsBACKSPACEPaste a name into a formulaF3Define a nameCTRL+F3Calculate all sheets in all open workbooksF9 Calculate the active worksheetSHIFT+F9Insert the AutoSum formulaALT+= (EQUAL SIGN)Enter the dateCTRL+; (SEMICOLON)Enter the timeCTRL+SHIFT+: (COLON)Insert a hyperlinkCTRL+KComplete a cell entryENTERCopy the value from the cell above the active cell into the cell or the formula barCTRL+SHIFT+" (QUOTATION MARK)Alternate between displaying cell values and displaying cell formulasCTRL+` (SINGLE LEFT QUOTATION MARK)Copy a formula from the cell above the active cell into the cell or the formula barCTRL+' (APOSTROPHE)Enter a formula as an array formulaCTRL+SHIFT+ENTERDisplay the Formula Palette after you type a valid function name in a formulaCTRL+AInsert the argument names and parentheses for a function, after you type a valid function name in a formulaCTRL+SHIFT+ADisplay the AutoComplete listALT+DOWN ARROW
Posted by Angel... on
Feb 22, 2011 | Microsoft Computers & Internet
Oct 23, 2010 | Microsoft Computers & Internet
Nov 08, 2009 | Microsoft Office Professional 2007 Full...
Aug 10, 2009 | Microsoft Excel for PC
203 people viewed this tip
Usually answered in minutes!