如何将条件格式单元格从Excel复制到Word?

时间:2021-01-30 20:23:00

I have tried to copy cells formatted with conditional formula from Excel to Word and only the text is copied. When copy-pasting the format is lost in word.

我试过将用条件公式格式化的单元格从Excel复制到Word,只复制文本。当复制粘贴时,格式将丢失在word中。

Any ideas?

什么好主意吗?

1 个解决方案

#1


1  

  1. Copy your range in excel
  2. 在excel中复制你的范围
  3. In Word, under the Home tab, click the down arrow under Paste (or right click) and
  4. 在Word中,在Home选项卡下,单击Paste(或右键单击)下的向下箭头
  5. Under Paste Options, select Keep Source Formatting (K)
  6. 在Paste选项下,选择Keep Source Formatting (K)

#1


1  

  1. Copy your range in excel
  2. 在excel中复制你的范围
  3. In Word, under the Home tab, click the down arrow under Paste (or right click) and
  4. 在Word中,在Home选项卡下,单击Paste(或右键单击)下的向下箭头
  5. Under Paste Options, select Keep Source Formatting (K)
  6. 在Paste选项下,选择Keep Source Formatting (K)