How to Copy Data in Google Sheets

Copying and pasting data in Google Sheets seems simple, but there's a lot more to it than just Ctrl+C and Ctrl+V. Knowing how to precisely control what you copy - from raw values and formulas to specific formatting rules - can save you hours of manual cleanup. This guide will walk you through everything, starting with the basics and moving on to advanced techniques that will make you a spreadsheet pro.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Basics: Your Standard Copy and Paste Toolkit

Let's start with the fundamental methods you'll use every day. These work for copying a single cell, a range of cells, or entire rows and columns.

1. Using Keyboard Shortcuts

The fastest way to work in Google Sheets is with keyboard shortcuts. If you learn nothing else, learn these two commands:

• To Copy: Select the cell(s) you want to copy. Press Ctrl + C (on Windows/ChromeOS) or Cmd + C (on Mac). You'll see a dashed blue line appear around your selection.
• To Paste: Click the cell where you want to paste the data. Press Ctrl + V (on Windows/ChromeOS) or Cmd + V (on Mac).

This standard paste operation copies everything: the values, the formulas, the formatting - the whole package.

2. Using the Right-Click Menu

If you prefer using your mouse, the right-click menu is your best friend.

1. Select the cells you wish to copy.
2. Right-click anywhere within the selected area.
3. Choose "Copy" from the dropdown menu.
4. Click on the destination cell, right-click again, and choose "Paste."

3. Using the Edit Menu

The third fundamental method is through the main menu at the top of your screen.

1. Select your desired data.
2. Navigate to Edit > Copy in the top menu bar.
3. Click your destination cell and go to Edit > Paste.

All three methods accomplish the same thing, so you can use whichever feels most comfortable for you.

Beyond the Basics: Unlocking "Paste Special"

"Paste Special" is where the real power lies. A standard paste brings everything over, but often, you only want a specific attribute of the source cell - like just the calculated result of a formula, not the formula itself, or just the cell's background color.

To access these options, copy your cells as usual (Ctrl+C), then right-click your destination cell and hover over Paste special. You can also find this in the Edit menu.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Paste values only (Ctrl + Shift + V)

This is arguably the most useful Paste Special command. It strips away all formulas and formatting, pasting only the final, raw data.

Example: Imagine cell A1 has the formula =TODAY(), which displays today's date, and it's formatted with a yellow background. If you regular-paste it into cell B1, you'll get the formula =TODAY() and the yellow background. But if you paste values only, cell B1 will contain the static text of today's date (e.g., "10/26/2023") with no formula or special formatting.

Paste format only

This does the opposite of the above. It ignores the values and formulas and copies only the formatting - font size, bolding, colors, borders, number formatting, etc.

Example: You've spent time designing a beautiful header row for a table. To apply that same style to another header row, copy the original, select the new one, and choose Paste format only. It will instantly match the style without overwriting your new text.

Paste formula only

Useful when you want to duplicate a calculation but not the visual styling. It copies the underlying formula but leaves the destination cell's existing formatting intact.

Paste transposed

This is a game-changer for restructuring data. "Transpose" switches a copied row into a column, or a column into a row.

Example: You have a list of monthly sales figures in a single row (A1:L1). To analyze this data vertically, copy the row, right-click a cell in a new column (e.g., M1), and select Paste transposed. Your horizontal data will instantly be pasted as a vertical list from M1 to M12.

Paste column widths only

Another amazing time-saver. If you have a set of columns with carefully adjusted widths and want to replicate that layout elsewhere, this is your tool. Simply copy the entire columns by clicking on their letters (e.g., A, B, C), and then use Paste column widths only on the destination columns.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Other Options

• Paste data validation only: Copies rules like dropdown menus without the cell's current value.
• Paste conditional formatting only: Copies rules that change a cell's format based on its value (e.g., "turn red if less than 0").
• Paste all except borders: Copies values, formulas, and formatting but ignores any border styles.

Efficiently Copying and Duplicating Entire Sheets

Sometimes you need more than a few cells - you need to copy an entire worksheet. Google Sheets makes this incredibly easy.

How to Duplicate a Sheet within the Same Spreadsheet

1. At the bottom of your screen, find the tab for the sheet you want to copy.
2. Right-click on the sheet tab (or click the small downward arrow).
3. Select "Duplicate" from the menu.

A new sheet tab will appear, titled "Copy of [Original Sheet Name]," containing an exact replica of the original sheet's data, formulas, and formatting.

How to Copy a Sheet to a Different Spreadsheet

You can also copy a full sheet to a completely separate Google Sheets file.

1. Right-click the tab of the sheet you want to move.
2. Select "Copy to..."
3. You'll get a popup allowing you to choose "New spreadsheet" or "Existing spreadsheet."
4. If you select "Existing spreadsheet," you can search through your Google Drive to find the destination file.
5. Once you make your choice, Google Sheets will create a copy of the worksheet in the other file.

Note: The formulas in the copied sheet will still reference the original spreadsheet unless you update them.

Advanced Method: Dynamically Copying Data with Formulas

For more advanced use cases, you might not want a static one-time copy. You might want data in one place to automatically update whenever the source data changes. This isn't really "copying" but rather dynamically pulling or mirroring data. The IMPORTRANGE function is built for this.

Using the IMPORTRANGE Function

The IMPORTRANGE function pulls a range of cells from one spreadsheet into another. The data remains "live," meaning if the source sheet is updated, the changes will automatically appear in the destination sheet.

The Formula Syntax:

=IMPORTRANGE("spreadsheet_url", "range_string")

How to Use It:

1. Get the Source URL: Open the spreadsheet you want to pull data from and copy its full URL from your browser's address bar.
2. Identify the Range: Make a note of the sheet name and cell range you want to import (e.g., "Sales Q3!A1:F50").
3. Write the Formula: In your destination spreadsheet, click on the cell where you want the data to start and type the formula. It should look something like this:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aBcDeFgHiJkLmNoPqRsTuVwXyZ...", "Sales Q3!A1:F50")

1. Allow Access: The first time you link two sheets, the cell will show a #REF! error. Hover over the cell, and a button will appear asking you to "Allow access." Click it to grant permission.

The data will now appear and will stay in sync with the source file.

Troubleshooting Common Copy-Paste Problems

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

#REF! Errors after Pasting Formulas

This is the most common issue. It happens because Google Sheets uses relative references by default. A formula like =A1+B1 in cell C1 really means "add the cell two spaces to my left and the cell one space to my left." When you copy that formula to cell G5, it will try to add E5 and F5.

If your formula breaks, check if you need absolute references. Use dollar signs ($) to lock a reference into place. For example, =$A$1+B1 tells Sheets to always look at cell A1, no matter where you copy the formula.

Dates Turning into Numbers

Ever copied a date and seen something like "45258"? This happens because spreadsheets store dates as serial numbers. The copy-paste process sometimes loses the date formatting. The fix is simple:

1. Select the cells with the incorrect numbers.
2. Go to Format > Number > Date in the top menu.

Copying Only Visible Cells from a Filtered View

By default, copying a range that has a filter applied will also copy the hidden rows. To grab just the visible data, you unfortunately can't do it with a direct copy command. The easiest workaround is:

1. Copy the filtered range as usual (hidden cells will come along).
2. In a new sheet, use Paste special > Paste values only. This will paste all the data (visible and hidden) in a block.
3. Now, with the new, clean data, you're free to sort or re-filter it without worrying about hidden cells from the original sheet.

Final Thoughts

Mastering the different ways to copy and paste data in Google Sheets transforms it from a simple data entry tool into a powerful data manipulation platform. From quick keyboard shortcuts and versatile Paste Special options to advanced dynamic functions like IMPORTRANGE, these techniques allow you to move and reshape your information with precision and speed.

While these spreadsheet skills are invaluable, a lot of this manual report-building is tedious work. That’s why we built Graphed to automate the most time-consuming parts. Instead of copying data from different sales and marketing platforms into Google Sheets, we allow you to connect your data sources directly. From there, you can just describe the dashboard you want in plain English, and it’s built for you in seconds - always live and up-to-date.