How To Select Multiple Cells In Google Sheets

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:

Step 1

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

Step 2

The two clicked cells and all cells between them will be selected and highlighted blue

Step 3

You can also click and drag across cells to select a range

Selecting Non Adjacent Cells

To select non adjacent cells, follow these steps:

Step 1

Click on the first cell you want to select

Step 2

Hold down the control key on your keyboard and continue to select additional cells by clicking on them one at a time

Step 3

You can unselect a cell by clicking on it again

Summary

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.