How To Multiple Cells In Google Sheets

In this tutorial, you will learn how to copy multiple cells in Google Sheets.

If you work in Google Sheets, you’ll likely have come across the need to copy multiple cells. For example, you might want to copy a range of data to another portion of the spreadsheet or into another document such as a word processor. While you could select each cell in turn and copy each of them, it’s much faster to copy them all at the same time. Read on to learn how

Select and Copy Cells

The key to copying multiple cells is first to select multiple cells. When selecting cells to copy, selections should be a single, contiguous range

Step 1

Click on the first cell you want to copy, then hold down Shift on your keyboard and select the last cell you want to copy

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

Step 4

Once you’ve selected a range of cells, copy the cells using the keyboard shortcut: Ctrl + C on Windows or Cmd + C on Mac

Step 5

You can then use the paste keyboard shortcut to paste the cells elsewhere in the spreadsheet or into another document. The keyboard shortcut for pasting is Ctrl + V on Windows or Cmd + V on Mac

Step 6

Repeat for any additional ranges of cells until you’ve copied all the desired cells


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to copy multiple cells in Google Sheets. Want more? Check out all the Google Sheets Tutorials.