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
Quick Navigation
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
Summary
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.