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
- Copy your range in excel
- 在excel中复制你的范围
- In Word, under the
Home
tab, click the down arrow underPaste
(or right click) and - 在Word中,在Home选项卡下,单击Paste(或右键单击)下的向下箭头
- Under
Paste Options
, selectKeep Source Formatting (K)
- 在Paste选项下,选择Keep Source Formatting (K)
#1
1
- Copy your range in excel
- 在excel中复制你的范围
- In Word, under the
Home
tab, click the down arrow underPaste
(or right click) and - 在Word中,在Home选项卡下,单击Paste(或右键单击)下的向下箭头
- Under
Paste Options
, selectKeep Source Formatting (K)
- 在Paste选项下,选择Keep Source Formatting (K)