Menu
My question is pretty much stated in the title. I have been trying to add a pivot table in the same sheet in which i have charts and other analysis done but when i try to add a pivot table it create a new sheet.
I am trying to convert an Excel dashboard into Google spreadsheet dashboard.
Thanks
298
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. If you want to, you can then delete the pivot table sheet.
How to make a pivot table from multiple sheets in Google spreadsheet? It often happens that the data, which is necessary for the analysis, is spread out into different tables. But the Pivot table can be built by using one data span only. You can't use the data from different tables to make a Google Sheets pivot table.
Once you have created the pivot table you can move it using CTRL + X. Just select all the table then use CTRL + X and paste wherever you want it, the problem is that once you change the data in the pivot table and it gets bigger you may overwrite other information in other cells, so you have to be very careful with that.
This is the only way I have found in Google Docs since there is no "move" option.
134
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
