Method(s) to select and work with more than one cell at a time in spreadsheets: [a] Drag & drop
[a] Mouse dragging [a] Right click
[a] Ctrl-click
[a] Double click
[a] Shift-click

Sometimes you may want to select a larger group of cells, or a cell range.

Click, hold, and drag the mouse until all of the adjoining cells you want to select are highlighted.Release the mouse to select the desired cell range. The cells will remain selected until you click another cell in the worksheet.