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 #385, your Monday morning espresso, in spreadsheet form! It's that time of year when you need hat and gloves one day and shorts and sunscreen the next. Last week, we had back-to-back days of 90°F. I'm sure it happens every Spring, but I always find it surprising how quickly the seasons change. Thankfully, we've also enjoyed plenty of days in the 60s and 70s (the preferred operating temperature of this Englishman). I...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #384, your Monday morning espresso, in spreadsheet form! Normally with these Google Sheets Tips, I make them as practical as possible, so that you can apply them to your work. Today, however, I'm going to show you The Ultimate Spreadsheet Prank as a way of understanding how custom number formats work. And if that doesn't float your spreadsheet boat, well then, I don't know what will. Find this tutorial below the news...
Hi Reader, Welcome to the Google Sheets Tips newsletter #383, your Monday morning espresso, in spreadsheet form! NASA's Artemis II mission blasted off towards the moon last week. I watched the launch live with my son (on YouTube, not in person, haha). The launch was exhilarating; I was holding my breath for the 10-second countdown! I'm excited to follow along with the remainder of the mission and see close-up images of the moon. In fact, as I press send on this email, they are scheduled to...