LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to guides
Excel Tips

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.

Save hours formatting your next financial spreadsheet!
100+ templates, all free to use.
Free Spreadsheet Templates

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 copy and paste by right-clicking
How to copy and paste by right-clicking in Google Sheets

How to copy and paste from the toolbar
How to copy and paste from the toolbar in Google Sheets

Learn Sheets for financial analysis today!
LiveFlow Academy teaches you the basics for free. Certificates available!
Enroll in LiveFlow Academy

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.

open the “Paste special” menu by right-clicking
How to open the “Paste special” menu by right-clicking in Google Sheets

show the “Paste special” menu from the toolbar
How to show the “Paste special” menu from the toolbar in Google Sheets

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.

Format painter
How to use the format painter in Google Sheets

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.

The world's top businesses trust LiveFlow to automate their financial reporting
We turn Quickbooks Online data into a live FP&A dashboard in Sheets FAST!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.