Excel keyboard shortcuts - Duke Global Health Institute ?· Excel keyboard shortcuts. ... Move from…

  • Published on
    26-Aug-2018

  • View
    212

  • Download
    0

Transcript

Hide AllKeyboard shortcuts listed in this topic refer to the U.S. keyboard layout. Keys on other keyboardlayouts might not correspond to the keys on a U.S. keyboard. Keyboard shortcuts for laptopcomputers might also differ.Some function key shortcuts conflict with default key assignments in Mac OS X version 10.3 or later. To use them,you must change the settings for your function keys. On the Apple menu, go to System Preferences. UnderHardware, click Keyboard > Keyboard and then check Use all F1, F2, etc. as standard function keys.Function keysTO PRESSOpen the Formula Builder SHIFT + F3orFN + SHIFT + F3Repeat the last Find (Find Next) SHIFT + F4orFN + SHIFT + F4Close the window + F4orFN + + F4Display the Go To dialog box F5Display the Find dialog box SHIFT + F5Move to the next pane in a workbook that has been split F6Move to the previous pane in a workbook that has been split SHIFT + F6Move to the next workbook window + F6Move to the previous workbook window + SHIFT + F6Check spelling F7orFN + F7Add to the selection SHIFT + F8Display the Macro dialog box OPTION + F8orFN + OPTION + F8Calculate all sheets in all open workbooks. F9Calculate the active sheet. SHIFT + F9Display a contextual menu. SHIFT + F10Insert a new chart sheet. F11Insert a new sheet. SHIFT + F11Insert an Excel 4.0 macro sheet + F11orFN + + F11Display the Save As dialog box. F12Display the Open dialog box + F12orFN + + F12Moving and scrolling in a sheet or workbookTO PRESSMove one cell up, down, left, or right An arrowkeyMove to the edge of the current data region CONTROL+ arrowkeyMove to the beginning of the row HOMEExcel keyboard shortcutsjavascript:AlterAllDivs('none');javascript:ToggleDiv('divExpCollAsst_507786187')javascript:ToggleDiv('divExpCollAsst_250230178')Move to the beginning of the row HOMEMove to the beginning of the sheet CONTROL+ HOMEMove to the last cell in use on the sheet, which is the cell at the intersection of the rightmostcolumn and the bottom row (in the lower-right corner); or the cell opposite the home cell,which is typically A1CONTROL+ ENDMove down one screen PAGEDOWNMove up one screen PAGE UPMove one screen to the right OPTION +PAGEDOWNMove one screen to the left OPTION +PAGE UPMove to the next sheet in the workbook CONTROL+ PAGEDOWNMove to the previous sheet in the workbook CONTROL+ PAGEUPMove to the next workbook or window CONTROL+ TABMove to the previous workbook or window CONTROL+ SHIFT +TABMove to the next pane in a workbook that has been split F6Move to the previous pane in a workbook that has been split SHIFT + F6Scroll to display the active cell CONTROL+ DELETEDisplay the Go To dialog box CONTROL+ GDisplay the Find dialog box + FRepeat the last Find action (same as Find Next) + GMove between unlocked cells on a protected sheet TABPreviewing and printingTO PRESSDisplay the Print dialog box + PEntering data on a sheetTO PRESSComplete a cell entry and move forward in the selection RETURNStart a new line in the same cell CONTROL + OPTION +RETURNFill the selected cell range with the text that you type CONTROL + RETURNComplete a cell entry and move back in the selection SHIFT + RETURNComplete a cell entry and move to the right in the selection TABComplete a cell entry and move to the left in the selection SHIFT + TABCancel a cell entry ESCDelete the character to the left of the insertion point, or delete theselectionDELETEDelete the character to the right of the insertion point, or delete theselectionDelete text to the end of the line CONTROL + javascript:ToggleDiv('divExpCollAsst_878311032')javascript:ToggleDiv('divExpCollAsst_651666536')Delete text to the end of the line CONTROL + Move one character up, down, left, or right An arrow keyMove to the beginning of the line HOMERepeat the last action + YEdit a cell comment SHIFT + F2Fill down CONTROL + DFill to the right CONTROL + RDefine a name CONTROL + LWorking in cells or the Formula barTO PRESSEdit the active cell and then clear it, or delete the preceding character in theactive cell as you edit the cell contentsDELETEComplete a cell entry RETURNEnter a formula as an array formula CONTROL + SHIFT +RETURNCancel an entry in the cell or formula bar ESCDisplay the Formula Builder after you type a valid function name in a formula CONTROL + AInsert a hyperlink + KEdit the active cell and position the insertion point at the end of the line CONTROL + UOpen the Formula Builder SHIFT + F3orFN + SHIFT + F3Calculate all sheets in all open workbooks + =Calculate the active sheet + SHIFT + =Start a formula =Toggle the formula reference style between absolute, relative, and mixed + TInsert the AutoSum formula + SHIFT + TEnter the date CONTROL + SEMICOLON(;)Enter the time + SEMICOLON (;)Copy the value from the cell above the active cell into the cell or the formulabarCONTROL + SHIFT +INCH MARK (")Alternate between displaying cell values and displaying cell formulas CONTROL + GRAVEACCENT (`)Copy a formula from the cell above the active cell into the cell or the formulabarCONTROL +APOSTROPHE (')Display the AutoComplete list CONTROL + OPTION +DOWN ARROWDefine a name CONTROL + LFormatting and editing dataTO PRESSDisplay the Style dialog box + SHIFT + LDisplay the Format Cells dialog box + 1Apply the general number format CONTROL + SHIFT +~Apply the currency format with two decimal places (negative numbers appear inred with parentheses)CONTROL + SHIFT +$Apply the percentage format with no decimal places CONTROL + SHIFT +%javascript:ToggleDiv('divExpCollAsst_548850720')javascript:ToggleDiv('divExpCollAsst_158134510')Apply the exponential number format with two decimal places CONTROL + SHIFT +^Apply the date format with the day, month, and year CONTROL + SHIFT +#Apply the time format with the hour and minute, and indicate A.M. or P.M. CONTROL + SHIFT +@Apply the number format with two decimal places, thousands separator, andminus sign (-) for negative valuesCONTROL + SHIFT +!Apply the outline border around the selected cells + OPTION + ZEROAdd an outline border to the right of the selection + OPTION + RIGHTARROWAdd an outline border to the left of the selection + OPTION + LEFTARROWAdd an outline border to the top of the selection + OPTION + UPARROWAdd an outline border to the bottom of the selection + OPTION +DOWN ARROWRemove outline borders + OPTION +HYPHENApply or remove bold formatting + BApply or remove italic formatting + IApply or remove underscoring + UApply or remove strikethrough formatting + SHIFT + XHide rows CONTROL + 9Unhide rows CONTROL + SHIFT +(Hide columns CONTROL + ZEROUnhide columns CONTROL + SHIFT +)Add or remove the shadow font style + SHIFT + WAdd or remove the outline font style + SHIFT + DEdit the active cell CONTROL + UCancel an entry in the cell or the formula bar ESCEdit the active cell and then clear it, or delete the preceding character in the activecell as you edit the cell contentsDELETEPaste text into the active cell + VComplete a cell entry RETURNEnter a formula as an array formula CONTROL + SHIFT +RETURNDisplay the Formula Builder after you type a valid function name in a formula CONTROL + AWorking with a selectionTO PRESSCopy the selection + CCut the selection + XPaste the selection + VClear the contents of the selection DELETEDelete the selection CONTROL +HYPHENCopy text or graphics to the Scrapbook CONTROL +OPTION + Cjavascript:ToggleDiv('divExpCollAsst_330424802')Paste to the Scrapbook CONTROL +OPTION + VUndo the last action + ZMove from top to bottom within the selection (down), or move in the direction that isselected in Edit in the Preferences dialog box (Excel menu, Preferences command)RETURNMove from bottom to top within the selection (up), or move opposite to the direction thatis selected in Edit in the Preferences dialog box (Excel menu, Preferences command)SHIFT +RETURNMove from left to right within the selection, or move down one cell if only one column isselectedTABMove from right to left within the selection, or move up one cell if only one column isselectedSHIFT + TABMove clockwise to the next corner of the selection CONTROL +PERIODInsert graphics using the Media Browser +CONTROL +MSelecting cells, columns, or rowsTO PRESSExtend the selection by one cell SHIFT+arrow keyExtend the selection to the last nonblank cell in the same column or row as the active cell + SHIFT+arrow keyExtend the selection to the beginning of the row SHIFT +HOMEExtend the selection to the beginning of the sheet CONTROL +SHIFT +HOMEExtend the selection to the last cell used on the sheet (lower-right corner) CONTROL +SHIFT + ENDSelect the entire column CONTROL +SPACEBARSelect the entire row SHIFT +SPACEBARSelect the entire sheet + ASelect only the active cell when multiple cells are selected SHIFT +DELETEExtend the selection down one screen SHIFT +PAGE DOWNExtend the selection up one screen SHIFT +PAGE UPAlternate between hiding objects, displaying objects, and displaying placeholders forobjectsCONTROL +6Show or hide the Standard toolbar CONTROL +7Turn on the capability to extend a selection by using the arrow keys F8Add another range of cells to the selection; or use the arrow keys to move to the start ofthe range you want to add, and then press F8 and the arrow keys to select the next rangeSHIFT + F8Select the current array, which is the array that the active cell belongs to CONTROL +/Select cells in a row that don't match the value in the active cell in that row. You mustselect the row starting with the active cell.CONTROL +\Select only cells that are directly referred to by formulas in the selection CONTROL +SHIFT + [javascript:ToggleDiv('divExpCollAsst_412831242')Select cells in a column that don't match the value in the active cell in that column. Youmust select the column starting with the active cell.CONTROL +|Select all cells that are directly or indirectly referred to by formulas in the selection CONTROL +SHIFT + {Select only cells with formulas that refer directly to the active cell CONTROL +]Select all cells with formulas that refer directly or indirectly to the active cell CONTROL +SHIFT + }Select only visible cells in the current selection + SHIFT +ZChartsTO PRESSInsert a new chart sheet. F11Cycle through chart object selection An arrow keyData formsTO PRESSMove to the same field in the next record DOWN ARROWMove to the same field in the previous record UP ARROWMove to the next field that you can edit in the record TABMove to the previous field that you can edit in the record SHIFT + TABMove to the first field in the next record RETURNMove to the first field in the previous record SHIFT + RETURNMove to the same field 10 records forward PAGE DOWNMove to the same field 10 records back PAGE UPMove one character left within a field LEFT ARROWMove one character right within a field RIGHT ARROWSelect the character to the left SHIFT + LEFT ARROWSelect the character to the right SHIFT + RIGHT ARROWFilters and PivotTable reportsTO PRESSDisplay the Filter list or PivotTable page field pop-up menu for the selectedcellOPTION + DOWNARROWOutlining dataTO PRESSDisplay or hide outline symbols CONTROL + 8Hide selected rows CONTROL + 9Unhide selected rows CONTROL + SHIFT + (Hide selected columns CONTROL + ZEROUnhide selected columns CONTROL + SHIFT + )ToolbarsTO PRESSMake the first button on a floating toolbar active OPTION + F10When a toolbar is active, select the next button or menu on the toolbar TABWhen a toolbar is active, select the previous button or menu on the toolbar SHIFT + TABPerform the action assigned to the selected button RETURNjavascript:ToggleDiv('divExpCollAsst_675767207')javascript:ToggleDiv('divExpCollAsst_414344484')javascript:ToggleDiv('divExpCollAsst_327330880')javascript:ToggleDiv('divExpCollAsst_613738443')javascript:ToggleDiv('divExpCollAsst_207434451')WindowsTO PRESSExpand or minimize the ribbon +OPTION+ RSwitch to the next application + TABSwitch to the previous application +SHIFT +TABClose the active workbook window + WRestore the active workbook window size + F5Move to the next pane in a workbook that has been split F6Move to the previous pane in a workbook that has been split SHIFT +F6Switch to the next workbook window + F6Switch to the previous workbook window +SHIFT +F6Copy the image of the screen to the Clipboard +SHIFT +3Copy the image of the active window to the Clipboard (after pressing and releasing the keycombination, click the window that you want to take a picture of). +SHIFT +4Dialog boxesTO PRESSMove to the next text box TABMove to the previous box, option, control, or command SHIFT + TABExit a dialog box or cancel an action ESCSwitch to the next tab CONTROL + TABSwitch to the previous tab CONTROL + SHIFT + TABPerform the action assigned to the default command button(the button with the bold outline, often the OK button)RETURNCancel the command and close ESCSee alsoCommon Office keyboard shortcutsCreate or delete a keyboard shortcutSite Directory Contact Us Submit Feedback Legal Trademarks Privacy and Cookies Accessibility 2014 Microsoft Corporation. All rights reserved. javascript:ToggleDiv('divExpCollAsst_258888571')javascript:ToggleDiv('divExpCollAsst_12208062')http://office.microsoft.com/en-us/mac-excel-help/redir/HA102927264.aspx?CTT=5&origin=HA102927337http://office.microsoft.com/en-us/mac-excel-help/redir/HA102927282.aspx?CTT=5&origin=HA102927337http://o15.officeredir.microsoft.com/r/rlidOOSiteDirectory?clid=1033&CTT=114http://o15.officeredir.microsoft.com/r/rlidOOContact?clid=1033&CTT=114http://o15.officeredir.microsoft.com/r/rlidOOFeedback?clid=1033&origin=HA102927337&CTT=114http://o15.officeredir.microsoft.com/r/rlidOOlegal?clid=1033&CTT=114http://o15.officeredir.microsoft.com/r/rlidTrademarks?clid=1033&CTT=114http://o15.officeredir.microsoft.com/r/rlidOOPrivacyStatement?clid=1033&CTT=114http://o15.officeredir.microsoft.com/r/rlidOOAccessibility?clid=1033&CTT=114http://o15.officeredir.microsoft.com/r/rlidMsCom?clid=1033&CTT=114