天气预报 > 其他 > 如何把数据透视表直接变成表格
如何把数据透视表直接变成表格
更新时间: 2020-09-24 00:00:00  

将数据透视表变成表格:

1、选择整个数据透视表;

2、复制数据透视表:在Excel 2003中单击工具栏中的“复制”按钮,在Excel 2007中右击数据透视表,然后选择“复制”;

3、右击需要粘贴数据的单元格,选择“选择性粘贴”,在“选择性粘贴”对话框中选择“数值”;

4、单击“确定”按钮。

关键词: 如何 数据 透视 直接 变成 表格

如何把数据透视表直接变成表格相关经验

天气预报

最新推荐

页面:/news/view-1704587/ | 耗时:0.1286 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=1704587 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1704587 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1704587 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1048712,1132895,144590,1774369,1578479,478533,237956,1508719,1438474,150794,1041531,1051075,317019,1115400,347838,1320926,1889653,375459,1119602,1671626,1346113,1089840,1847072,1489700,135209,1607266,1281866,1702885,1963826,1863497) ORDER BY field (ArticleID,1048712,1132895,144590,1774369,1578479,478533,237956,1508719,1438474,150794,1041531,1051075,317019,1115400,347838,1320926,1889653,375459,1119602,1671626,1346113,1089840,1847072,1489700,135209,1607266,1281866,1702885,1963826,1863497)