When a portion of a formula is selected, calculate the selected portion and then press Enter or Ctrl+Shift+Enter (for array formulas) to replace the selected portion with the calculated value.Ĭalculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. Insert an AutoSum formula with the SUM function.Ĭopy the value from the cell above the active cell into the cell or the formula bar.Ĭopy a formula from the cell above the active cell into the cell or the formula bar.Īlternate between displaying cell values and displaying formulas.Ĭalculate all worksheets in all open workbooks. When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses. When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box. In a formula, display the Insert Function dialog box.
In the formula bar, delete one character to the left.Ĭomplete a cell entry from the cell or formula bar.Ĭancel an entry in the cell or formula bar. Move one character up, down, left, or right.ĭisplay a drop-down list of the values in the current column of a range. Shortcut Keys for Data Entry, Formatting, and Calculating DataĬomplete a cell entry and select the next cell below.įill the selected cell range with the current entry.Ĭomplete a cell entry and select the next cell above.Ĭomplete a cell entry and select the next cell to the right.Ĭomplete a cell entry and select the previous cell to the left. Table 5.5 shows the shortcut keys you use for entering, editing, formatting, and calculating data. Then press F8 and the arrow keys to select the next range.Į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 used cell on the worksheet in the lower-right corner.Įxtend the selection to the last cell in the current row.Įxtend the selection to the cell in the upper-left corner of the window.Įxtend the selection to the cell in the lower-right corner of the window. In Extend mode, EXT appears in the status line and the arrow keys extend the selection.Īdd another range of cells to the selection or use the arrow keys to move to the start of the range you want to add. Table 5.4 shows the shortcut keys you use to extend a selection. Select the visible cells in the current selection.
Select cells that contain formulas that directly or indirectly reference the active cell. Select cells that contain formulas that directly reference the active cell. Select all cells directly or indirectly referenced by formulas in the selection. Select all cells directly referenced by formulas in the selection. In a selected column, select the cells that do not match the value in the active cell. In a selected row, select the cells that do not match the value in the active cell. Select the array containing the active cell. With multiple cells selected, revert selection to only the active cell. If inside a table, toggle between selecting the table row and the entire row. If used inside a table, toggle between selecting the data, data and headers, and the entire column. If used outside a table, select entire column. Shortcut Keys for Selecting Data and Cells Table 5.3 shows the shortcut keys you use to select data and cells. When more than one workbook is open, switch to the next open workbook window. Switch to next pane in a window that has been split. Move to last cell in the used range of the worksheet. Table 5.2 illustrates the shortcut keys that you use to navigate.
Excel keyboard shortcuts 2010 windows#
Table 5.1 lists the common Windows Ctrl shortcut keys. In fact, many of these keys are consistent across all Windows applications. Excel 2010 automatically recognizes all the Ctrl shortcut keys that were used in legacy versions of Excel.
0 kommentar(er)
