In this tutorial, you will learn how to copy cells in Google Sheets.
How To Copy Cells In Google Sheets
Copying data from one cell to another is a common action in Google Sheets. Whether you want to move a single cell, a range of cells, or an entire row or column, you can easily do so with a few clicks.
In this guide, we will show you how to copy cells in Google Sheets. We’ll also show you a few useful Paste Special commands that might be useful when working with your data.
How to Copy and Paste Cells in Google Sheets
Here’s our guide on how to copy and paste cells in Google Sheets.
Let’s start by copying a range of cells in Google Sheets.
First, use your cursor to select the top-left-most cell in the range.
While holding the Shift key, click on the bottom-right-most cell in the desired range.
In our example, we’ve selected cell B12 as the last cell in our selection.
Type the keyboard shortcut Ctrl + C to copy the selection.
Select another cell as the destination for the copied range. Ensure that there is enough space to the right and below this cell to accommodate the range once pasted.
Use the keyboard shortcut Ctrl + V to paste the copied cells into the chosen destination.
Any cell that falls within the pasted range will be overwritten.
Other than the regular paste option, users can also choose to perform a Paste Special action.
You can find all the Paste special option by right-clicking on the destination cell.
The Values only option cell will strip away any formatting from the original cell range as well as convert formulas to the actual values. You can use the shortcut key Ctrl+Shift+V to paste just the values of your selection.
Alternatively, users can choose the Format only option which maintains cell formatting settings such as cell borders, cell background colors, and text alignment. You can use the shortcut key Ctrl+Alt+V to paste just the format of the selection.
Other Paste special options include the Transposed option that converts rows to columns and vice versa.
This guide should be everything you need to copy and paste cells in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.