profile

Google Sheets Tips

Sheets Tip 337: Quickly Duplicate Pivot Tables

Published about 1 year ago • 1 min read

Brought to you by:


Hi Reader,

Welcome to the Google Sheets Tips newsletter #337, your Monday morning espresso, in spreadsheet form!

I'm sharing a simple pivot table trick today that's one of those hidden gems in spreadsheets. Once you know it, you'll never go back.

Suppose you create a complex pivot table and you want to create a second version so you can try a different filter perhaps. Well, today's trick lets you quickly duplicate the pivot table, rather than having to build again from the ground up. Check it out below.

Brought to you by: BudgetSheet

Save Time This Tax Season With BudgetSheet

Why not automate the most tedious part of doing your taxes this tax season?

BudgetSheet can automatically import all your bank transactions into Google Sheets and categorize them for you. It's quick, it's secure, and it couldn't be easier. Join over 15k satisfied users today!

➜ News

I.
​All Workspace business users now have access to new Gemini capabilities in Sheets.

​Read more >>​

II.
​Here's an article for you Apps Scripters out there...

​How Apps Script Became the Ultimate LLM Fine-Tuning Tool​

➜ Sheets Tip #337: Quickly Duplicate a Pivot Table

Have you ever wanted to duplicate a Pivot Table, perhaps as a starting point for further data exploration?

Well, there's a quick trick for copying an existing Pivot Table, rather than starting over.

  • Click on the top left corner cell of your Pivot Table
  • Copy the pivot table (Cmd + C on a Mac, or Ctrl + C on a PC/Chromebook)
  • Paste an identical pivot table copy wherever you like in your Sheet (Cmd + V on a Mac, or Ctrl + V on a PC/Chromebook).

In this example, the top left cell is B2. I click on that cell, copy it and then paste a new pivot table below, in cell B10:

Easy peasy, lemon squeezy!

Bonus tip: you can also delete pivot tables quickly by selecting this top left cell and pressing Delete.

Both of these tips only work with the top left cell of the pivot table.

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. Features of adulthood​

Google Sheets Tips

by Ben Collins

Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.

Read more from Google Sheets Tips

Hi Reader, Welcome to the Google Sheets Tips newsletter #388, your Monday morning espresso, in spreadsheet form! ➜ Sheets Tip #388: Merged Cells To many power users who live in spreadsheets, merged cells are often treated like a patch of poison ivy on a hiking trail. They see them, turn their nose up, and steer well clear. But are they always the villain? Let's find out. Why Purists Cringe At Merged Cells In a structured dataset or a table, merged cells are, quite frankly, a nightmare. They...

1 day ago • 1 min read

Hi Reader, Welcome to the Google Sheets Tips newsletter #387, your Monday morning espresso, in spreadsheet form! I'm traveling so no news section again this week. But don't worry, I'll have a full recap of all the relevant Google Next announcements soon. ➜ Sheets Tip #387: Do You Know How To Round Numbers To The Nearest Hundred, Thousand? We’ve all used the ROUND function to tidy up messy decimals. But do you know one of its best tricks? It works equally as well to round to the nearest ten or...

8 days ago • 1 min read

Hi Reader, Welcome to the Google Sheets Tips newsletter #386, your Monday morning espresso, in spreadsheet form! Similar to Sheets Tip #384 from a couple of weeks ago, we're keeping it light hearted with today's tip. In this case, I'm showing you one of Google Sheets' secret easter egg functions! Read on to find out what it is and what it does. ➜ Sheets Tip #386: Is your Sheet feeling crowded? Build a meadow 🐑 We’ve all been there: you’re focused on giving a demonstration in your Sheet to...

15 days ago • 1 min read