Function keys in Microsoft Excel



Select cells, columns, rows, or objects in worksheets and workbooks by using shortcut keysToPressSelect the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)CTRL+SHIFT+* (ASTERISK)Extend the selection by one cellSHIFT+ arrow keyExtend the selection to the last nonblank cell in the same column or row as the active cellCTRL+SHIFT+ arrow keyExtend the selection to the beginning of the rowSHIFT+HOMEExtend the selection to the beginning of the worksheetCTRL+SHIFT+HOMEExtend the selection to the last cell used on the worksheet (lower-right corner)CTRL+SHIFT+ENDSelect the entire columnCTRL+SPACEBARSelect the entire rowSHIFT+SPACEBARSelect the entire worksheetCTRL+AIf multiple cells are selected, select only the active cellSHIFT+BACKSPACEExtend the selection down one screenSHIFT+PAGE DOWNExtend the selection up one screenSHIFT+PAGE UPWith an object selected, select all objects on a sheetCTRL+SHIFT+SPACEBARAlternate between hiding objects, displaying objects, and displaying placeholders for objectsCTRL+6Show or hide the Standard toolbarCTRL+7In End mode, toPressTurn End mode on or offENDExtend the selection to the last nonblank cell in the same column or row as the active cellEND, SHIFT+ arrow keyExtend the selection to the last cell used on the worksheet (lower-right corner)END, SHIFT+HOMEExtend the selection to the last cell in the current row; this keystroke is unavailable if you selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command)END, SHIFT+ENTERWith SCROLL LOCK on, toPressTurn SCROLL LOCK on or offSCROLL LOCKScroll the screen up or down one rowUP ARROW or DOWN ARROWScroll the screen left or right one columnLEFT ARROW or RIGHT ARROWExtend the selection to the cell in the upper-left corner of the windowSHIFT+HOMEExtend the selection to the cell in the lower-right corner of the windowSHIFT+ENDTip When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to keep the same selection as you scroll, turn on SCROLL LOCK first.Edit data by using shortcut keysToPressEdit the active cellF2Cancel an entry in the cell or formula barESCEdit 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 formulaF3Complete a cell entryENTEREnter 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+A Insert, delete, and copy a selection by using shortcut keysToPressCopy the selectionCTRL+CPaste the selectionCTRL+VCut the selectionCTRL+XClear the contents of the selectionDELETEInsert blank cellsCTRL+SHIFT+PLUS SIGNDelete the selectionCTRL+ –Undo the last actionCTRL+ZMove and scroll on a worksheet or workbook by using shortcut keysToPressMove one cell in a given directionArrow keyMove to the edge of the current data regionCTRL+ arrow keyMove between unlocked cells on a protected worksheetTABMove to the beginning of the rowHOMEMove to the beginning of the worksheetCTRL+HOMEMove to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1CTRL+ENDMove down one screen PAGE DOWNMove up one screen PAGE UPMove one screen to the rightALT+PAGE DOWNMove one screen to the leftALT+PAGE UPMove to the next sheet in the workbookCTRL+PAGE DOWNMove to the previous sheet in the workbookCTRL+PAGE UPMove to the next workbook or windowCTRL+F6 or CTRL+TABMove to the previous workbook or windowCTRL+SHIFT+F6 or CTRL+SHIFT+TABMove to the next paneF6Move to the previous paneSHIFT+F6Scroll to display the active cellCTRL+BACKSPACEIn End mode, toPressTurn End mode on or offENDMove by one block of data within a row or columnEND, arrow keyMove to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1END, HOMEMove to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command)END, ENTERWith SCROLL LOCK turned on, toPressTurn SCROLL LOCK on or offSCROLL LOCKMove to the cell in the upper-left corner of the windowHOMEMove to the cell in the lower-right corner of the windowENDScroll one row up or downUP ARROW or DOWN ARROWScroll one column left or rightLEFT ARROW or RIGHT ARROWTip When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to preserve your selection while you scroll through the worksheet, turn on SCROLL LOCK first.Enter data by using shortcut keysToPressComplete 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 ARROWFormat data by using shortcut keysToPressDisplay the Style command (Format menu)ALT+' (APOSTROPHE)Display the Cells command (Format menu)CTRL+1Apply the General number formatCTRL+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 placesCTRL+SHIFT+^Apply the Date format with the day, month, and yearCTRL+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, 1000 separator, and – for negative valuesCTRL+SHIFT+!Apply the outline borderCTRL+SHIFT+&Remove all bordersCTRL+SHIFT+_Apply or remove bold formattingCTRL+BApply or remove italic formattingCTRL+IApply or remove an underlineCTRL+UApply or remove strikethrough formattingCTRL+5Hide rowsCTRL+9Unhide rowsCTRL+SHIFT+(Hide columnsCTRL+0 (ZERO)Unhide columnsCTRL+SHIFT+)Print and preview a document by using shortcut keys and Work in print previewToPressDisplay the Print command (File menu)CTRL+PMove around the page when zoomed inArrow keysMove by one page when zoomed outPAGE UP or PAGE DOWNMove to the first page when zoomed outCTRL+UP ARROW or CTRL+LEFT ARROWMove to the last page when zoomed outCTRL+DOWN ARROW or CTRL+RIGHT ARROWWork with the AutoFilter feature by using shortcut keysToPressDisplay the AutoFilter list for the current columnSelect the cell that contains the column label, and then press ALT+DOWN ARROWClose the AutoFilter list for the current columnALT+UP ARROWSelect the next item in the AutoFilter listDOWN ARROWSelect the previous item in the AutoFilter listUP ARROWSelect the first item (All) in the AutoFilter listHOMESelect the last item in the AutoFilter listENDFilter the list by using the selected item in the AutoFilter listENTERFunction keys in Microsoft ExcelFunction keySHIFTCTRLALTCTRL+SHIFTALT+SHIFTF1Display Help or the Office AssistantWhat's This?Insert a chart sheetInsert a new worksheetF2Edit the active cellEdit a cell commentSave As commandSave commandF3Paste a name into a formulaPaste a function into a formulaDefine a nameCreate names by using row and column labelsF4Repeat the last actionRepeat the last Find (Find Next)Close the windowExitF5Go To Display the Find dialog boxRestore the window sizeF6Move to the next paneMove to the previous paneMove to the next workbook windowMove to the previous workbook windowF7Spelling commandMove the windowF8Extend a selectionAdd to the selectionResize the windowDisplay the Macro dialog box F9Calculate all sheets in all open workbooksCalculate the active worksheet Minimize the workbook F10Make the menu bar activeDisplay a shortcut menuMaximize or restore the workbook windowF11Create a chartInsert a new worksheetInsert a Microsoft Excel 4.0 macro sheetDisplay Visual Basic EditorF12Save As commandSave commandOpen commandPrint command ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download