Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Sheets Tip 337: Quickly Duplicate Pivot Tables
|
Brought to you by:
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. ➜ NewsI. II. How Apps Script Became the Ultimate LLM Fine-Tuning Tool ➜ Sheets Tip #337: Quickly Duplicate a Pivot TableHave 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.
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, P.S. Features of adulthood |
Google Sheets Tips
Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #373, your Monday morning espresso, in spreadsheet form! January is a great time to sharpen your Google Sheets fundamentals: those small skills you build now that will save you time all year. One of the best examples is learning a few simple keyboard shortcuts, which is what we're going to see today. You probably already use Ctrl + C and Ctrl + V to copy and paste values, and can appreciate how this is quicker than...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #372, your Monday morning espresso, in spreadsheet form! Hoping your 2026 is off to a great start! I'm feeling positive and optimistic for 2026, but reality has also kept me grounded ;) I've only had one work day so far (kids were off sick most of last week, thankfully both better) and I'm now under the weather myself. But it's not too bad and hopefully will pass within a day or two. I finally published my end-of-year...
Brought to you by: Hi Reader, Happy New Year! 🎉 Welcome to the Google Sheets Tips newsletter #371, your first Monday morning espresso of 2026, in spreadsheet form! I usually write a year-in-review post over the holidays but this holiday was so busy that I didn't get round to it. It's a valuable exercise to reflect on the year gone and think about what I want to achieve this year. So I'm still planning to write one and will share it when I do. I hope you had a wonderful holiday season and feel...