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 #338, your Monday morning espresso, in spreadsheet form! After a last bite from winter last week, it looks like spring is finally here where I live on the east coast of the US. The daffodils are growing, the box turtles are out sunning themselves on logs by the river, and temperatures are forecast in the 70s (in the 20s celcius). Wherever you are, I hope you're enjoying the changing of the seasons. ➜ News I.Google...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #336, your Monday morning espresso, in spreadsheet form! This week, we're looking at use cases for the text rotation tool. I don't use it often but it's a nice technique for styling your Sheets. I've used it to add branding to my Sheets (see use case 2 below). Find tip #336 below our sponsor message and a few articles to share from the spreadsheet world. Brought to you by: BudgetSheet Save Time This Tax Season With...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #335, your Monday morning espresso, in spreadsheet form! Today, I'm sharing some formulas that I use all the time: date formulas. I do a lot of project management planning in Sheets so I'm always needing to generate sequences of dates. Below, you'll find a roundup of the most useful. But first, I'm delighted to share today's sponsor with you. If you're serious about working with data then learning how to code with the...