How to Select Multiple Cells in Google Sheets
- Alai Umerez |
- 9 steps |
- 17 seconds
1
Look for the Google Apps icons at the top right corner of your browser
2
To access the Google Sheets application, simply click on the "Sheets" option
3
Open the specific Google Sheets document you wish to work with or select "Blank Spreadsheet" to create a new document
How to Select Multiple Cells By Clicking and Dragging
4
Position your mouse pointer over the first cell in the range you want to select
Once positioned, click and hold down the left mouse button
5
While keeping the mouse button pressed, move the cursor across the spreadsheet
Drag it horizontally, vertically, or diagonally to cover the range of cells you wish to highlight
As you drag, you’ll notice the cells becoming highlighted to indicate they are selected
How to Select Multiple Cells By Selecting Range
6
Position your mouse pointer over the first cell in the range you want to select
7
On your keyboard, press and hold down the "Shift" key
While continuing to hold down the "Shift" key, click on the last cell in the range you wish to include
This action will automatically highlight all the cells between the first cell you clicked and this final one, forming a continuous block of selected cells
How to Select Multiple Non-Contiguous Cells
Note:
This method allows you to pick cells that are not directly next to one another without deselecting the previously selected ones
8
Position your mouse pointer over the first cell you want to select
9
Hold down the "Ctrl" key (or "Cmd" key on a Mac) and click on each individual cell you want to include in your selection
