Sheets Tip 337: Quickly Duplicate Pivot Tables


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​

Future Proof: One AI tutorial a week. Stay relevant.

Join our community of over 43,000 readers and get the Future Proof newsletter: an actionable AI tutorial every Monday (think of it as your Monday morning espresso, in AI form).

Read more from Future Proof: One AI tutorial a week. Stay relevant.
Scheduled Actions in AI tools

Hi Reader, Welcome to the Future Proof newsletter, your Monday morning espresso, in AI form! Today's tip is a simple one, but it's super useful. Scheduled Actions let you put AI to work automatically in the background, handling recurring prompts, research, and daily check-ins on a set schedule. Find out how to create them below. But first, some news from the world of Google Sheets, Workspace, and AI. → News I.Earlier this year, Google launched Sheets Canvas, which lets you turn spreadsheet...

Add a QA check to prompts to make them more accurate

Hi Reader, Welcome to the Future Proof newsletter, your Monday morning espresso, in AI form! (Formerly the Google Sheets Tips newsletter.) One of the stories that jumped out to me in the past week came from an interview with a tearful Cornell mathematics professor, asking "what's the point?" when AI surpasses human ability and steals the meaning (and joy) from mathematical research. (Which is a calling, not just a job to many.) One line stuck with me, and I'm paraphrasing here, but basically,...

Add custom Gemini instructions in sidebar of Google Sheets

Hi Reader, Welcome to the Future Proof newsletter issue 5, your Monday morning espresso, in AI form! (Formerly the Google Sheets Tips newsletter.) Lots of Gemini and Google Workspace news to share today and a tip on custom instructions. Find it all below, but first a little anecdote from my weekend. Kids say the funniest things. My 9-year-old declared over the weekend that he was going to build his own AI company and call his AI tool "Psycho"! I laughed and told him I loved the name. I was...