How to Copy and Paste in Google Sheets
In this article, you will learn basic and special ways to copy and paste values in Google Sheets.
What are copy and paste in Google Sheets?
"copy and paste" are essential functions in Google Sheets that allow you to duplicate the content of one or more cells and place it elsewhere within the sheet.
In addition to the general copy and paste functions, you have the “special paste” function in Google Sheets with which we can paste a part of the copied content (e.g., only value, only formatting, or only column width, etc.). You need to select the proper way of pasting depending on your use case to make your work easier and more efficient.
When are copy and paste functions useful in Google Sheets?
The copy-and-paste functions in Google Sheets can be helpful in a variety of situations:
- Duplicating data: If you have data in one cell or group of cells that you want to duplicate elsewhere in the sheet, you can use the copy-and-paste function to do so quickly.
- Moving data: If you want to transfer data from one location to another within the same sheet, you can use the copy-and-paste function to do so and delete the original data.
- Formatting cells: If you have a set of cells that are formatted the way you want, you can use the copy and paste function (special paste) to apply the same formatting to other cells.
How to use the copy-and-paste functions in Google Sheets
There are three ways to use the (general) copy-and-paste functions in Google Sheets, but we highly recommend you use the first approach as it is the most efficient way to save time.
- Shortcut keys
- Right-clicking
- The “Edit” tab in the toolbar
Using shortcut keys with your keyboard
- Select a cell or a range you want to copy.
- Press “Ctrl” + “C” for Windows and “⌘” + “C” for Mac.
- Select a cell (or the top left corner cell in case of a range) to which you want to paste the copied data.
- Press “Ctrl” + “V” for Windows and “⌘” + “V” for Mac.
Right-clicking on your mouse / Navigating to the “Edit” tab in the toolbar
- Select a cell or a range you want to copy.
- Right-click or navigate to the “Edit” tab in the toolbar.
- Click “Copy”.
- Select a cell (or the top left corner cell in case of a range) to which you want to paste the copied data.
- Right-click or navigate to the “Edit” tab in the toolbar.
- Select “Paste”.
How to use “Paste special” in Google Sheets
You can use the special paste function with the same approaches as the general paste function.
- Shortcut keys (Only available to “Values only” and “Format only”)
- Right-clicking → “Paste special”
- The “Edit” menu in the toolbar → “Paste special”
Using shortcut keys with your keyboard
- Select a cell or a range you want to copy.
- Press “Ctrl” + “C” for Windows and “⌘” + “C” for Mac.
- Select a cell (or the top left corner cell in case of a range) to which you want to paste the copied data.
- If you want to paste values only, press “Ctrl” + “Shift” + “V” for Windows and “⌘” + ”Shift” + “V” for Mac. In case you want to paste format only, press “Ctrl” + “Alt” + “V” for Windows and “⌘” + “Alt” + “V” for Mac.
Right-clicking on your mouse / Navigating to the “Edit” tab in the toolbar
- Select a cell or a range you want to copy.
- Right-click or navigate to the “Edit” tab in the toolbar.
- Click “Copy”.
- Select a cell (or the top left corner cell in case of a range) to which you want to paste the copied data.
- Right-click or navigate to the “Edit” tab in the toolbar.
- Select “Paste special”.
- Choose one of the special paste options available.
You have eight types of “special paste” in Google Sheets as follows:
Values only: Only a value in the original cell is pasted. The shortcuts are “Ctrl” + “Shift” + “V” for Windows and “⌘” + ”Shift” + “V” for Mac.
Format only: Only cell format (without any formula and text strings) is pasted. The shortcuts are “Ctrl” + “Alt” + “V” for Windows and “⌘” + “Alt” + “V” for Mac.
Formula only: This allows you to paste only a formula without its result. A returned value by the pasted formula may be different from the initial result because of the reference types used in the formula.
Conditional formatting only: Only conditional formatting is pasted in a destination cell.
Data validation only: You paste the data validation rule only.
Transposed: This enables you to paste something while swapping the row and column of the copied range or array. This is helpful when you want to convert a horizontally long dataset into a vertically long one or vice versa.
All except borders: This helps you paste everything except cell borders.
Column widths only: This option makes the widths of the columns where data is pasted the same as those of the original columns where the pasted data comes from.
How to use the format painter in Google Sheets
The format painter (or the “Format painter” icon) is next to the printer icon in the toolbar in Google Sheets, as shown in the picture below.
This icon gives you the ability to copy the data and paste only the format (equivalent to “Format only” in “Paste special” described in the section above)
- Select a cell or range whose formatting you want to copy and paste.
- Click the “Paint format” icon, which saves the format in the clipboard.
- Click a cell (or the top left corner cell of a range) to which you want to paste the format.
.png){kind=small}
