Is it possible to have a pivot table on the same sheet as the data it's referencing in a Google Sheet?
At the moment if I create a pivot table it always creates a new sheet.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityIs it possible to have a pivot table on the same sheet as the data it's referencing in a Google Sheet?
At the moment if I create a pivot table it always creates a new sheet.
Simply select the cells of the pivot table you want to copy and then copy and paste it in the spreadsheet or sheet where you want it (or select desired cells and use CTRL + X and then CTRL + V to move it). If you want to, you can then delete the pivot table sheet.