将文本插入到单元格的背景中 [英] Insert text into the background of a cell
本文介绍了将文本插入到单元格的背景中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在寻找一种将文本插入到单元格的背景中,以便我仍然可以在该文本的顶部输入数字 - 类似于除了单个单元格之外的水印。任何方式来做,最好不使用宏(但也可以使用这些解决方案)?
I am looking for a way to insert text into the background of a cell, so that I can still enter numbers on top of that text - similar to a watermark except for an individual cell. Any ways to do this, preferably without using a macro (but open to these solutions as well)?
推荐答案
- 选择要制作背景的单元格。
- 单击插入,然后在该位置插入矩形形状。
- 右点击形状 - 选择格式化形状
- 转到填充并选择图片或纹理填充
- 转到从文件插入选项
- 选择要制作水印的图片
- 图片将出现在矩形的地方
- 现在点击图片右键单击,然后选择格式化图片
- 转到填充,并根据需要增加透明度,使其看起来像水标记或浅色的 / li>
- 这样也会打印出来。
- Select the Cell where you want to make the Background.
- Click "Insert" and insert a rectangular Shape in that location.
- Right click on the shape - select "Format Shape"
- Goto "Fill" and select "Picture or texture fill"
- Goto "Insert from File" option
- Select the picture you want to make water-mark
- Picture will appear at the place of rectangular shape
- Now click on the picture "right click" and select Format Picture
- Goto "Fill" and increase the transparency as required to look it like a "Water Mark" or light beckground
- This will get printed also.
这篇关于将文本插入到单元格的背景中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文