Select the first cell, and then press Ctrl+ Shift+ Home to extend the selection of cells to the beginning of the worksheet.Click 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).To stop extending the selection, press F8 again. Click the first cell in the range, and then press F8 to extend the selection by using the arrow keys.Click the first cell in the range, hold down Shift while you press the arrow keys to extend the selection.Click the first cell in the range, and then hold down Shift while you click the last cell.Click the first cell in the range, and then drag to the last cell.Press Ctrl+ A to select the current region around the active cell.If the active cell is one of the data range, pressing and hold down the Ctrl key on the keyboard, then press twice A, then all cells selected.If the active cell is not above or to the left of the data, pressing Ctrl+ A to select all cells.click the Select All button selects the entire worksheet.Click the cell, or press the arrow keys to move to the cell.Use any of these methods to select cells in a worksheet: Select A Single Cell You can also want to select all or a range of cells and turn on Editing mode so that you can modify the data.

You may want to select multiple cells, ranges, rows, or columns in a worksheet in order to format the data in the selection, or to insert other cells, rows, or columns.

Excel 2016 select visible cells only