Excel allows you to select cells in several different ways, using both the mouse and the keyboard.
Selecting with a mouse by dragging
Look at the following example. It contains 16 cells filled with data. To select them, click cell B2 and drag the cursor to cell E5. After you release the mouse button the cells will be selected. You can start selecting them from any corner of the table.
Selecting cells by using the Shift key
In the second method of selecting data, we will use the Shift key. In this case, click any corner of the table, then, while holding down the Shift key, click the opposite corner.
Selecting cells with the Ctrl + A keyboard shortcut
To use the third method, click any cell that is located in the table, then use the Ctrl + A keyboard shortcut.
Selecting the entire worksheet with the Ctrl + A keyboard shortcut
To select all cells in a worksheet, use Ctrl + A twice or click the icon in the upper-left corner of the worksheet.
Selecting non-adjacent cells
If you want to choose non-adjacent cells, click or click and drag different cells while holding down the Ctrl key.