Google电子表格:在活动工作表中插入数据透视表. [英] Google spreadsheets: Insert pivot table in the active sheet.

问题描述

我的问题在标题中已经有很多说明.我一直在尝试在已完成图表和其他分析的工作表中添加数据透视表，但是当我尝试添加数据透视表时，它会创建一个新工作表.

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.

我正在尝试将Excel仪表板转换为Google电子表格仪表板.

I am trying to convert an Excel dashboard into Google spreadsheet dashboard.

谢谢

推荐答案

只需选择要复制的数据透视表的单元格，然后将其复制并粘贴到所需的电子表格或工作表中.如果需要，则可以删除数据透视表.

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.

这篇关于Google电子表格:在活动工作表中插入数据透视表.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！