数据透视表和数据交叉表_将数据透视表自定义样式复制到其他工作簿

数据透视表和数据交叉表

How can you copy a pivot table custom style to a different workbook? There isn't a built-in way to do that, but there is a workaround solution. There are instructions that worked in Excel 2013, and earlier versions (way back to Excel 2007). Those stopped working, unfortunately, but there's an easy way to do this in Excel 2016 too.

如何将数据透视表自定义样式复制到其他工作簿？ 没有内置的方法可以执行此操作，但是有一种解决方法。 有些说明在Excel 2013和早期版本(可追溯到Excel 2007)中起作用。 不幸的是，那些人停止了工作，但是在Excel 2016中也有一种简单的方法来做到这一点。

创建数据透视表自定义样式 (Create a Pivot Table Custom Style)

Excel comes with many built-in PivotTable Styles, in Light, Medium and Dark colour themes. You can quickly apply any of those styles to the selected pivot table – just open the style palette, and click on the style that you want to apply.

Excel带有许多内置的数据透视表样式，具有浅色，中色和深色主题。 您可以将任何这些样式快速应用于选定的数据透视表-只需打开样式面板，然后单击要应用的样式即可。

You can't change those built-in styles, but you can create your own pivot table custom style, based on a built-in style. Then, modify your custom style, with the formatting that you want.

您无法更改这些内置样式，但是可以基于内置样式创建自己的数据透视表自定义样式。 然后，以所需的格式修改自定义样式。

This video shows how to create a custom style from an existing style, and make changes to its formatting.

该视频显示了如何从现有样式创建自定义样式，以及如何更改其格式。

演示地址

在Excel 2013中复制自定义样式 (Copy Custom Style in Excel 2013)

If you're using Excel 2013 or earlier, this short video shows how to copy one of your fancy custom styles into a different workbook.

如果您使用的是Excel 2013或更早版本，则此短片将演示如何将其中一种精美的自定义样式复制到其他工作簿中。

There are written instructions on my website, if you'd rather read than watch.

如果您不想阅读而不是观看，我的网站上有书面说明 。

NOTE: If you're using Excel 2016, see the instructions in the next section.

注意 ：如果您使用的是Excel 2016，请参阅下一节中的说明。

演示地址

在Excel 2016中复制自定义样式 (Copy Custom Style in Excel 2016)

Thanks to Annie Cushing from Annielytics.com, who let me know that the old method  to copy a pivot table custom style wasn't working in Excel 2016.

感谢Annielytics.com的Annie Cushing ，他让我知道复制数据透视表自定义样式的旧方法在Excel 2016中不起作用。

With a bit of experimenting, I found a new way to copy the custom style. It's even easier than the old way, and it worked in Excel 2016 and Excel 2013.

经过一些试验，我找到了一种复制自定义样式的新方法。 它比旧方法更容易，并且可以在Excel 2016和Excel 2013中使用。

1. Open the workbook (A) with the pivot table that has the custom style applied.
   使用已应用自定义样式的数据透视表打开工作簿(A)。
2. Open the workbook (B) where you want to add that custom style
   打开要在其中添加该自定义样式的工作簿(B)
3. Position the workbooks, so you can see the sheet tabs in both files
   放置工作簿，以便您可以在两个文件中看到工作表标签
4. Press the Ctrl key, and drag a copy of the pivot table sheet from workbook A, into the workbook B.
   按Ctrl键，然后将数据透视表工作表的副本从工作簿A拖到工作簿B中。
5. The custom style is now copied into the new workbook, and you can see it in the PivotTable Style palette.
   现在，自定义样式已复制到新工作簿中，您可以在“数据透视表样式”调板中看到它。
6. In workbook B, you can delete the sheet that you copied from workbook A.
   在工作簿B中，您可以删除从工作簿A复制的工作表。

更多数据透视表格式提示 (More Pivot Table Format Tips)

For more pivot table formatting tips, go to the Excel Pivot Table Format page on my Contextures site.

有关更多数据透视表格式设置技巧，请转到Contextures网站上的“ Excel数据透视表格式”页 。

There are written instructions and videos, that show how to create and copy PivotTable Styles, keep pivot table formatting, and other tips.

有书面说明和视频，显示了如何创建和复制数据透视表样式，如何保持数据透视表格式以及其他技巧。

翻译自: https://contexturesblog.com/archives/2018/04/19/copy-a-pivot-table-custom-style-to-different-workbook/

数据透视表和数据交叉表