EXCEL VIDEO TUTORIALS / EXCEL DASHBOARD REPORTS

Ozgrid, Experts in Microsoft Excel Spreadsheets

Excel keyboard Shortcuts

| | Information Helpful? Why Not Donate.

 

SEE ALSO: Excel Shortcuts

Current Special! Complete Excel Excel Training Course for Excel 97 - Excel 2003, only $145.00. $59.95 Instant Buy/Download, 30 Day Money Back Guarantee & Free Excel Help for LIFE!

Got any Excel Questions? Free Excel Help

Keys for moving and scrolling in a worksheet or workbookArrow keys: Move one cell up, down, left, or rightCTRL+arrow: key Move to the edge of the current data regionHOME: Move to the beginning of the rowCTRL+HOME: Move to the beginning of the worksheet

CTRL+END: Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1

PAGE DOWN: Move down one screenPAGE UP: Move up one screenALT+PAGE DOWN: Move one screen to the rightALT+PAGE UP: Move one screen to the leftCTRL+PAGE DOWN: Move to the next sheet in the workbookCTRL+PAGE UP: Move to the previous sheet in the workbookCTRL+F6 or CTRL+TAB: Move to the next workbook or windowCTRL+SHIFT+F6 or CTRL+SHIFT+TAB: Move to the previous workbook or windowF6: Move to the next pane in a workbook that has been splitSHIFT+F6: Move to the previous pane in a workbook that has been splitCTRL+BACKSPACE: Scroll to display the active cellF5: Display the Go To dialog boxSHIFT+F5: Display the Find dialog boxSHIFT+F4: Repeat the last Find action (same as Find Next)TAB: Move between unlocked cells on a protected worksheet

Keys for moving in a worksheet with End mode onEND: Turn End mode on or offEND, arrow key: Move by one block of data within a row or columnEND, HOME: Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1END, ENTER: Move 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) Keys for moving in a worksheet with SCROLL LOCK onSCROLL LOCK: Turn SCROLL LOCK on or offHOME: Move to the cell in the upper-left corner of the windowEND: Move to the cell in the lower-right corner of the windowUP ARROW or DOWN ARROW: Scroll one row up or downLEFT ARROW or RIGHT ARROW: Scroll one column left or rightTip   When you use 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. Keys for previewing and printing a documentCTRL+P or CTRL+SHIFT+F12: Display the Print dialog box Work in print previewArrow keys: Move around the page when zoomed inPAGE UP or PAGE DOWN: Move by one page when zoomed outCTRL+UP ARROW or CTRL+LEFT ARROW: Move to the first page when zoomed outCTRL+DOWN ARROW or CTRL+RIGHT ARROW: Move to the last page when zoomed out Keys for working with worksheets, charts, and macrosSHIFT+F11 or ALT+SHIFT+F1: Insert a new worksheetF11 or ALT+F1: Create a chart that uses the current rangeALT+F8: Display the Macro dialog boxALT+F11: Display the Visual Basic EditorCTRL+F11: Insert a Microsoft Excel 4.0 macro sheetCTRL+PAGE DOWN: Move to the next sheet in the workbookCTRL+PAGE UP: Move to the previous sheet in the workbookSHIFT+CTRL+PAGE DOWN: Select the current and next sheet in the workbookSHIFT+CTRL+PAGE UP: Select the current and previous sheet in the workbook Keys for entering data on a worksheetENTER: Complete a cell entry and move down in the selectionALT+ENTER: Start a new line in the same cellCTRL+ENTER: Fill the selected cell range with the current entrySHIFT+ENTER: Complete a cell entry and move up in the selectionTAB: Complete a cell entry and move to the right in the selectionSHIFT+TAB: Complete a cell entry and move to the left in the selectionESC: Cancel a cell entryBACKSPACE: Delete the character to the left of the insertion point, or delete the selectionDELETE: Delete the character to the right of the insertion point, or delete the selectionCTRL+DELETE: Delete text to the end of the lineArrow keys: Move one character up, down, left, or rightHOME: Move to the beginning of the lineF4 or CTRL+Y: Repeat the last actionSHIFT+F2: Edit a cell commentCTRL+SHIFT+F3: Create names from row and column labelsCTRL+D: Fill downCTRL+R: Fill to the rightCTRL+F3: Define a name Keys for working in cells or the formula barBACKSPACE: Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contentsENTER: Complete a cell entryCTRL+SHIFT+ENTER: Enter a formula as an array formulaESC: Cancel an entry in the cell or formula barCTRL+A: Display the Formula Palette after you type a function name in a formulaCTRL+SHIFT+A: Insert the argument names and parentheses for a function after you type a function name in a formulaCTRL+K: Insert a hyperlinkENTER (in a cell with a hyperlink): Activate a hyperlinkF2: Edit the active cell and position the insertion point at the end of the lineF3: Paste a defined name into a formulaSHIFT+F3: Paste a function into a formulaF9: Calculate all sheets in all open workbooksCTRL+ALT+F9: Calculate all sheets in the active workbookSHIFT+F9: Calculate the active worksheet= (equal sign): Start a formulaALT+= (equal sign): Insert the AutoSum formulaCTRL+; (semicolon): Enter the dateCTRL+SHIFT+: (colon): Enter the timeCTRL+SHIFT+" (quotation mark): Copy the value from the cell above the active cell into the cell or the formula barCTRL+` (single left quotation mark): Alternate between displaying cell values and displaying cell formulasCTRL+' (apostrophe): Copy a formula from the cell above the active cell into the cell or the formula barALT+DOWN ARROW: Display the AutoComplete list
Keys for formatting data

ALT+' (apostrophe): Display the Style dialog boxCTRL+1: Display the Format Cells dialog boxCTRL+SHIFT+~: Apply 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 placesCTRL+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, thousands separator, and minus sign () for negative valuesCTRL+SHIFT+&: Apply the outline borderCTRL+SHIFT+_: Remove outline bordersCTRL+B: Apply or remove bold formattingCTRL+I: Apply or remove italic formattingCTRL+U: Apply or remove an underlineCTRL+5: Apply or remove strikethrough formattingCTRL+9: Hide rowsCTRL+SHIFT+( (opening parenthesis): Unhide rowsCTRL+0 (zero): Hide columnsCTRL+SHIFT+) (closing parenthesis): Unhide columns Keys for editing dataF2: Edit the active cell and put the insertion point at the end of the lineESC: Cancel an entry in the cell or formula barBACKSPACE: Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contentsF3: Paste a defined name into a formulaENTER: Complete a cell entryCTRL+SHIFT+ENTER: Enter a formula as an array formulaCTRL+A: Display the Formula Palette after you type a function name in a formulaCTRL+SHIFT+A: Insert the argument names and parentheses for a function, after you type a function name in a formulaF7: Display the Spelling dialog box Keys for inserting, deleting, and copying a selectionCTRL+C: Copy the selectionCTRL+X: Cut the selectionCTRL+V: Paste the selectionDELETE: Clear the contents of the selectionCTRL+HYPHEN: Delete the selectionCTRL+Z: Undo the last actionCTRL+SHIFT+PLUS SIGN: Insert blank cells Keys for moving within a selectionENTER: Move from top to bottom within the selection (down), or move in the direction that is selected on the Edit tab (Tools menu, Options command)SHIFT+ENTER: Move from bottom to top within the selection (up), or move opposite to the direction that is selected on the Edit tab (Tools menu, Options command)TAB: Move from left to right within the selection, or move down one cell if only one column is selectedSHIFT+TAB: Move from right to left within the selection, or move up one cell if only one column is selectedCTRL+PERIOD: Move clockwise to the next corner of the selectionCTRL+ALT+RIGHT ARROW: Move to the right between nonadjacent selectionsCTRL+ALT+LEFT ARROW: Move to the left between nonadjacent selections Keys for selecting cells, columns, or rowsCTRL+SHIFT+* (asterisk): Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns)SHIFT+arrow key: Extend the selection by one cellCTRL+SHIFT+arrow key: Extend the selection to the last nonblank cell in the same column or row as the active cellSHIFT+HOME: Extend the selection to the beginning of the rowCTRL+SHIFT+HOME: Extend the selection to the beginning of the worksheetCTRL+SHIFT+END: Extend the selection to the last used cell on the worksheet (lower-right corner)CTRL+SPACEBAR: Select the entire columnSHIFT+SPACEBAR: Select the entire rowCTRL+A: Select the entire worksheetSHIFT+BACKSPACE: Select only the active cell when multiple cells are selectedSHIFT+PAGE DOWN: Extend the selection down one screenSHIFT+PAGE UP: Extend the selection up one screenCTRL+SHIFT+SPACEBAR: With an object selected, select all objects on a sheetCTRL+6: Alternate between hiding objects, displaying objects, and displaying placeholders for objectsCTRL+7: Show or hide the Standard toolbarF8: Turn on extending a selection by using the arrow keysSHIFT+F8: Add another range of cells to the selection; or use the arrow keys to move to the Start of the range you want to add, and then press F8 and the arrow keys to select the next rangeSCROLL LOCK, SHIFT+HOME: Extend the selection to the cell in the upper-left corner of the windowSCROLL LOCK, SHIFT+END: Extend the selection to the cell in the lower-right corner of the windowTip   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. Keys for extending the selection with End mode onEND: Turn End mode on or offEND, SHIFT+arrow key: Extend the selection to the last nonblank cell in the same column or row as the active cellEND, SHIFT+HOME: Extend the selection to the last cell used on the worksheet (lower-right corner)END, SHIFT+ENTER: Extend 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). Keys for selecting cells that have special characteristicsCTRL+SHIFT+* (asterisk): Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns)CTRL+/: Select the current array, which is the array that the active cell belongs toCTRL+SHIFT+O (the letter O): Select all cells with commentsCTRL+\: Select cells in a row that don't match the value in the active cell in that row. You must select the row Starting with the active cell.CTRL+SHIFT+|: Select cells in a column that don't match the value in the active cell in that column. You must select the column Starting with the active cell.CTRL+[ (opening bracket): Select only cells that are directly referred to by formulas in the selectionCTRL+SHIFT+{ (opening brace): Select all cells that are directly or indirectly referred to by formulas in the selectionCTRL+] (closing bracket): Select only cells with formulas that refer directly to the active cellCTRL+SHIFT+} (closing brace): Select all cells with formulas that refer directly or indirectly to the active cellALT+; (semicolon): Select only visible cells in the current selection Keys for selecting a chart sheetCTRL+PAGE DOWN: Select the next sheet in the workbook, until the chart sheet you want is selectedCTRL+PAGE UP: Select the previous sheet in the workbook, until the chart sheet you want is selected Keys for selecting an embedded chart

Note   The Drawing toolbar must already be displayed.

  1. Press F10 to make the menu bar active.
  2. Press CTRL+TAB or CTRL+SHIFT+TAB to select the Drawing toolbar
  3. Press the RIGHT ARROW key to select the Select Objects  button on the Drawing toolbar.
  4. Press CTRL+ENTER to select the first object.
  5. Press the TAB key to cycle forward (or SHIFT+TAB to cycle backward) through the objects until sizing handles appear on the embedded chart you want to select.
  6. Press CTRL+ENTER to make the chart active.

Keys for selecting chart itemsDOWN ARROW: Select the previous group of itemsUP ARROW: Select the next group of itemsRIGHT ARROW: Select the next item within the groupLEFT ARROW: Select the previous item within the group Keys for working with a data formALT+key, where key is the underlined letter in the field or command name: Select a field or a command buttonDOWN ARROW: Move to the same field in the next recordUP ARROW: Move to the same field in the previous recordTAB: Move to the next field you can edit in the recordSHIFT+TAB: Move to the previous field you can edit in the recordENTER: Move to the first field in the next recordSHIFT+ENTER: Move to the first field in the previous recordPAGE DOWN: Move to the same field 10 records forwardCTRL+PAGE DOWN: Move to a new recordPAGE UP: Move to the same field 10 records backCTRL+PAGE UP: Move to the first recordHOME or END: Move to the beginning or end of a fieldSHIFT+END: Extend a selection to the end of a fieldSHIFT+HOME: Extend a selection to the beginning of a fieldLEFT ARROW or RIGHT ARROW: Move one character left or right within a fieldSHIFT+LEFT ARROW: Select the character to the leftSHIFT+RIGHT ARROW: Select the character to the right Keys for using AutoFilterArrow keys to select the cell that contains the column label, and then press ALT+DOWN ARROW: Display the AutoFilter list for the current columnDOWN ARROW: Select the next item in the AutoFilter listUP ARROW: Select the previous item in the AutoFilter listALT+UP ARROW: Close the AutoFilter list for the current columnHOME: Select the first item (All) in the AutoFilter listEND: Select the last item in the AutoFilter listENTER: Filter the list by using the selected item in the AutoFilter list Keys for outlining dataALT+SHIFT+RIGHT ARROW: Group rows or columnsALT+SHIFT+LEFT ARROW: Ungroup rows or columnsCTRL+8: Display or hide outline symbolsCTRL+9: Hide selected rowsCTRL+SHIFT+( (opening parenthesis): Unhide selected rowsCTRL+0 (zero): Hide selected columnsCTRL+SHIFT+) (closing parenthesis): Unhide selected columns Keys for the PivotTable and PivotChart WizardUP ARROW or DOWN ARROW: Select the previous or next field button in the listLEFT ARROW or RIGHT ARROW: Select the field button to the left or right in a multicolumn field button listALT+C: Move the selected field into the Column areaALT+D: Move the selected field into the Data areaALT+L: Display the PivotTable Field dialog boxALT+P: Move the selected field into the Page areaALT+R: Move the selected field into the Row area Keys for page fields in a PivotTable or PivotChart reportCTRL+SHIFT+* (asterisk): Select the entire PivotTable reportArrow keys to select the cell that contains the field, and then ALT+DOWN ARROW: Display the list for the current field in a PivotTable reportArrow keys to select the page field in a PivotChart report, and then ALT+DOWN ARROW: Display the list for the current page field in a PivotChart reportUP ARROW: Select the previous item in the listDOWN ARROW: Select the next item in the listHOME: Select the first visible item in the listEND: Select the last visible item in the listENTER: Display the selected itemSPACEBAR: Select or clear a check box in the list Keys for laying out a PivotTable or PivotChart report

  1. Press F10 to make the menu bar active.
  2. Press CTRL+TAB or CTRL+SHIFT+TAB to select the PivotTable toolbar.
  3. Press the LEFT ARROW or RIGHT ARROW key to select the menu to the left or right or, when a submenu is visible, to switch between the main menu and submenu.
  4. Press ENTER (on a field button) and the DOWN ARROW and UP ARROW keys to select the area you want to move the selected field to.

Note   To scroll to the top or bottom of the field list, press ENTER on the More Fields  or  button. Keys for grouping and ungrouping PivotTable itemsALT+SHIFT+RIGHT ARROW: Group selected PivotTable itemsALT+SHIFT+LEFT ARROW: Ungroup selected PivotTable items Keys to use with the OLAP Cube WizardUse these keys to complete Step 2 in the OLAP Cube Wizard. To move a field from the Source fields list to the Dimensions box

  1. Press the TAB key to select the Source fields list.
  2. Press the UP ARROW or DOWN ARROW key to select the field you want to move. Because you cannot change the order of a field after you move it, select first the field you want to appear at the top of the Dimensions box.
  3. Press the TAB key to select the > button, and then press ENTER.
  4. To move other fields, repeat steps 1 through 3.

To move a field to a lower or higher level in the Dimensions box

  1. Press the TAB key to select the Dimensions box.
  2. Press the UP ARROW or DOWN ARROW key to select the field you want to move.
  3. Press CTRL+X.
  4. Press the UP ARROW or DOWN ARROW key to select where you want to move the field.
  5. Press CTRL+V.
    Excel Dashboard Reports & Excel Dashboard Charts

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.  See Software Categories

Instant Download and Money Back Guarantee on Most Software

Add to Google Search Tips

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Excel Data Manipulation and Analysis

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

FREE Excel Help