如何将条件格式从一个文档复制到另一个文档? [英] How can I copy a conditional formatting from one document to another?

问题描述

Google Spreadsheets可以将单元格格式复制到目标单元格，但是似乎没有复制条件格式"信息.

Google Spreadsheets can copy cell format to destination cell, but it seems "Conditional formatting" information didn't be copied.

我们可以仅将条件格式"从一个文档复制到另一个文档吗?

Can we just copy the "Conditional formatting" from one document to another?

我知道我们可以从条件格式"对话框中重新创建它，但这确实很耗时，但是如果我们仅能复制和粘贴，那就太好了.

I know we can recreate it from the "Conditional formatting" dialog but it's really time consuming, whereas if we can just copy and paste, then it's fantastic.

推荐答案

如果要将条件格式复制到另一个文档，则可以使用工作表的复制到..."功能(单击名称为的选项卡底部的工作表)，然后将工作表复制到其他文档中.

If you want to copy conditional formatting to another document you can use the "Copy to..." feature for the worksheet (click the tab with the name of the worksheet at the bottom) and copy the worksheet to the other document.

然后，您可以从该工作表中复制所需内容，然后右键单击选择选择性粘贴"->仅粘贴条件格式"，如前所述.

Then you can just copy what you want from that worksheet and right-click select "Paste special" -> "Paste conditional formatting only", as described earlier.

这篇关于如何将条件格式从一个文档复制到另一个文档?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！