In this tutorial, you will learn how to select multiple cells in Google Sheets.
When working in Google Sheets, it’s not uncommon to perform the same tasks on multiple different cells or ranges. For example, you might want to apply formatting to multiple cells, or copy multiple cells to paste into another document. While you could select each cell in turn and repeat the task for each, it’s much faster to select multiple cells and only perform the desired task once
Read on to learn how to select multiple cells
Selecting Adjacent Cells
To select adjacent cells, follow these steps:
Click on the first cell you want to select, then hold down Shift on your keyboard and select the last cell you want to select
The two clicked cells and all cells between them will be selected and highlighted blue
You can also click and drag across cells to select a range
Selecting Non Adjacent Cells
To select non adjacent cells, follow these steps:
Click on the first cell you want to select
Hold down the control key on your keyboard and continue to select additional cells by clicking on them one at a time
You can unselect a cell by clicking on it again
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to select multiple cells in Google Sheets. Want more? Check out all the Google Sheets Tutorials.