How to Copy a Pivot Table in Google Sheets

Trying to copy a pivot table in Google Sheets can feel like it should be simple, but it often leads to frustrating results like broken formulas or static data that won't update. That's because a pivot table isn't just a grid of cells, it's a dynamic tool connected to a source dataset. This guide will walk you through the correct ways to copy a pivot table, whether you need a static snapshot or a fully functional duplicate you can edit independently.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

First, Understand What You're Copying

Before jumping into the "how," it's important to understand the "what." A pivot table has two key parts: the visible output (the summarized rows and columns you see) and the underlying configuration (the connection to your source data, a set of rules in the Pivot table editor). When you blindly copy and paste, you often only get the visible output, leaving the dynamic connection behind.

The method you choose depends on your goal:

• Do you need a static, unchangeable snapshot of the data for a report or presentation?
• Or do you need a second, fully functional pivot table that you can modify without affecting the original?

We'll cover both scenarios in detail.

Method 1: Copying a Pivot Table as Static Values

This is the simplest method and is perfect when you need to capture a point-in-time snapshot of your pivot table data. The result will be regular cells filled with text and numbers - it will look identical, but it will no longer be a pivot table and will not update if your source data changes.

When to use this method:

• Pasting data into an email, Google Doc, or Google Slides presentation.
• Sending a non-editable summary to a colleague.
• Using the summarized data as the source for a different type of chart.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step-by-Step Instructions

Follow these simple steps to paste your pivot table as values only:

1. Click anywhere on your pivot table to select it.
2. Use your mouse to highlight the entire range of the visible pivot table data, including headers. Be careful not to select the entire sheet.
3. Copy the selected cells by pressing Ctrl + C (on Windows) or Cmd + C (on Mac).
4. Click on the cell where you want the top-left corner of your copied data to go. This can be in the same sheet, a different sheet, or even a different Google Sheets document.
5. Right-click on the destination cell and navigate to Paste special > Values only. You can also use the keyboard shortcut Ctrl + Shift + V (Windows) or Cmd + Shift + V (Mac).

That's it! You'll now have a clean, static copy of your pivot table's results. The formatting (like colors, bolding, and number formats) won't be copied over with this method, which is often ideal for a clean paste.

Pro Tip: Pasting Formatting Separately

If you want to preserve the visual style of your original pivot table, you can do a second "paste special" operation. After you've pasted the values, right-click the same destination cell again and choose Paste special > Format only. This will apply all the original colors, fonts, and borders to your new static table.

Method 2: Creating a Functional, Editable Duplicate of a Pivot Table

This is where most people get stuck. If you want to create a true, functional duplicate of a pivot table to analyze the data from a different angle - without altering your original - a simple copy and paste won't work. The easiest and most reliable way to achieve this is by duplicating the entire sheet.

When to use this method:

• When you want to create a variation of a report, maybe with different filters or columns, while keeping the original intact.
• To compare two views of the same data side-by-side (e.g., monthly sales vs. quarterly sales).
• As a quick way to create a template for future pivot tables based on the same data structure.

The Easiest Way: Duplicate the Entire Sheet

Instead of trying to copy the pivot table object itself, you'll simply duplicate the sheet it lives on. This creates a perfect clone of everything on the sheet, including the pivot table and its connection to the source data.

1. Locate the sheet tab containing your pivot table at the bottom of the Google Sheets window.
2. Right-click on the sheet tab.
3. Select Duplicate from the context menu.

A new sheet will appear, usually named "Copy of [Original Sheet Name]." This new sheet contains a brand new, fully independent pivot table. You can now click on this new pivot table and use the Pivot table editor to change its rows, columns, values, or filters without any impact on the original table on the first sheet. Both pivot tables will still update based on changes to the original source data range, but their configurations are completely separate.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Common Problems and How to Fix Them

Even with the right methods, you can run into issues. Here are a couple of the most common problems and their solutions.

Problem: My Copied Pivot Table Shows a #REF! Error

A #REF! error means the pivot table has lost its connection to the source data. This almost always happens when you try to copy the pivot table to a different spreadsheet document and the source data doesn't come with it.

The Fix: The best way to move a pivot table to a new Google Sheet is a two-step process:

1. First, make sure both your raw data and your pivot table are in the same sheet (or at least the same Google Sheets file).
2. Right-click the sheet tab containing your pivot table and select Copy to > Existing spreadsheet.
3. Choose the destination spreadsheet from your Google Drive.

This method copies the entire sheet - including the source data if it's on the same sheet and the fully functional pivot table - over to your other file, preserving a clean connection and preventing #REF! errors.

Problem: Why Slicers Don't Work on a Duplicated Pivot Table

If you use slicers to control your original pivot table, you might notice they don't affect the duplicated table. Slicers in Google Sheets are connected to a specific pivot table or data range, not to all pivot tables created from that data.

The Fix: After you duplicate your pivot table, you need to create a new slicer for it.

1. Click on your newly duplicated pivot table.
2. Go to Data > Add a Slicer from the main menu.
3. Configure the new slicer just as you did for the original one.

You will now have two independent slicers, one for each pivot table, allowing you to filter them separately.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Is There a Better Way Than Copying and Pasting?

While mastering the copy-paste and duplicate functions for pivot tables is a valuable skill, it's also worth asking if this is the most efficient way to manage your reports. The typical workflow often looks like this:

• Pull data from various sources (Google Analytics, your CRM, ad platforms).
• Consolidate everything into one massive Google Sheet.
• Create a master pivot table, then spend time copying, duplicating, and tweaking it to answer different questions.
• Repeat this entire manual process every week or every month.

This "spreadsheet wrangling" is time-consuming, prone to human error, and locks your valuable insights into static, disconnected reports. Every time you need an updated view, you're back to another round of copying and pasting.

Final Thoughts

Figuring out how to copy a pivot table in Google Sheets comes down to knowing what you need. If you need a static snapshot, use the simple Copy > Paste special > Values only method. If you need a live, editable duplicate to create a new report view, replicating the entire sheet via the Duplicate feature is your most reliable option.

We built Graphed to eliminate this kind of repetitive, manual reporting work entirely. Instead of moving data into spreadsheets and wrangling pivot tables, you can connect your data sources (like Google Analytics, Shopify, and Salesforce) directly. From there, you just ask questions in plain English, like "Show me revenue by marketing channel for the last 90 days," and we instantly create a real-time, shareable dashboard for you. It's about getting straight to the insights without getting stuck in the process of building the report.