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.

  • No, you can't (and pivot tables are ~evil~). Learn array formula. You can put a lot of pivot-like table in the same sheet using regular functions. It takes practice but worths the effort if you do lots of data analysis.
    – daniel
    Jul 26 '18 at 16:32

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.

  • would this retain the "live" / "editable" nature of the pivot table ?
    – sam
    Nov 25 '18 at 15:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.