Hold down SHIFT while you click the last cell that you want to include in the new selection. More or fewer cells than the active selection Select the first cell, and then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet. Select the first cell, and then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on the worksheet (lower-right corner). Press CTRL+END to select the last cell on the worksheet or in an Excel list that contains data or formatting.Ĭells to the last used cell on the worksheet (lower-right corner) Press CTRL+HOME to select the first cell on the worksheet or in an Excel list. The first or last cell on a worksheet or in a Microsoft Office Excel table Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). The first or last cell in a row or column Or select the first row or column then hold down SHIFT while you select the last row or column.Ĭlick the column or row heading of the first row or column in your selection then hold down CTRL while you click the column or row headings of other rows or columns that you want to add to the selection. Pressing CTRL+SHIFT+ARROW key a second time selects the entire row or column.ĭrag across the row or column headings. Note: If the row or column contains data, CTRL+SHIFT+ARROW key selects the row or column to the last used cell. To select the entire worksheet, click the Select All button at the top left corner. To select a list or table, select a cell in the list or table and press Ctrl + A. To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers. Or click on any cell in the row and then press Shift + Space. Select the row number to select the entire row. Or click on any cell in the column and then press Ctrl + Space. Select the letter at the top to select the entire column. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells. Or use the Shift + arrow keys to select the range. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the keyboard to navigate to it and select it. Select one or more cellsĬlick on a cell to select it. Note: If a worksheet has been protected, you might not be able to select cells or their contents on a worksheet.
0 Comments
Leave a Reply. |