There are a few notable methods to select multiple cells in Excel, and they are discussed below:
Click and drag: To choose a specific group of cells, click on a cell, hold down the left mouse button, and drag the cursor to cover those cells. To choose the range, let go of the mouse button.
Shift key: Choose the first cell in the range, then choose the last cell in the range while holding down the Shift key. The initial and last cells themselves are also included in the selection of cells between them.
Ctrl key: To select a specific cell, click it while depressing the Ctrl key. You can choose non-contiguous cells or ranges by doing this.