![]() ![]() 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. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |