For drawing objects: Alternate between hiding objects and displaying objects. Select only the active cell when multiple cells are selectedįor chart objects: Alternate between hiding objects, displaying objects, and displaying placeholders for objects. Select the entire worksheet, or, if an object is selected, all the objects on a worksheet
Select only visible cells in the current selectionĮxtend the selection to the last nonblank cell in the same column or row as the active cellĮxtend the selection to the beginning of the rowĮxtend the selection to the beginning of the worksheetĮxtend the selection to the last cell used on the worksheet (lower-right corner) Select all cells with formulas that refer directly or indirectly to the active cell Select only cells with formulas that refer directly to the active cell Select all cells that are directly or indirectly referred to by formulas in the selection Select only cells that are directly referred to by formulas in the selection In a selected column, or a selection within a column, select cells that don't match the value in the active cell. In a selected row, or a selection within a row, select cells that don't match the value in the active cell. Select the current array, which is the array that the active cell belongs to Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)
Selecting cells that have special characteristics Inserting, deleting, and copying a selection or P.M.Īpply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values Insert the argument names and parentheses for a function, after you type a valid function name in a formulaĬomplete a cell entry and move down in the selection, or move in the direction that is selected on the Edit tab (Edit menu, Preferences command)įill the selected cell range with the text that you type (works on nonadjacent selections)Ĭomplete a cell entry and move up in the selection, or move opposite to the direction that is selected on the Edit tab (Edit menu, Preferences command)Ĭomplete a cell entry and move to the right in the selection, or move in the direction that is selected on the Edit tab (Edit menu, Preferences command)Ĭomplete a cell entry and move to the left in the selection, or move opposite to the direction that is selected on the Edit tab (Edit menu, Preferences command)ĭelete the character to the left of the insertion point, or delete and edit the active cellĭelete the character to the right of the insertion point, or delete the selectionĭelete text from the insertion point to the end of the lineĪpply the Currency format with two decimal places (negative numbers appear in parentheses)Īpply the Percentage format with no decimal placesĪpply the Exponential number format with two decimal placesĪpply the Date format with the day, month, and the Time format with the hour and minute, and indicate A.M. When you are editing a cell, delete the character to the left of the insertion point.ĭisplay the Formula Palette after you type a valid function name in a formula Microsoft Excel 2001 (Mac) Keyboard ShortcutsĬancel an entry in the cell or formula barĬlear or edit the active cell.
0 kommentar(er)
