将图片放入单元格的背景中。不是整张纸 [英] to place picture into cell's background. not whole sheet

查看:86
本文介绍了将图片放入单元格的背景中。不是整张纸的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

hi
我搜索了很多,但找不到如何将图片放入单元格作为背景的方法。这意味着,完成之后,如果我点击单元格,我必须能够像更改之前一样写入单元格。

我不想通过注释或形状来解决问题,因为图片将位于单元格顶部。而不是作为背景



谢谢

hi i googled a lot, but can't find method how put picture into cell as background. it means, after it's done, if i click on cell, i must be able write into cell like before change.
i dont want solution through comments or shapes because picture will be on top of cell. and not as background

thanks

推荐答案

忽略VBA部分,我不确定你能不能这样做 - 你可以设置一个工作表的背景,你可以设置一个形状的背景,但我从来没有见过在excel中添加单元格背景图像的方法,并且快速谷歌没有显示任何这两种方式 - 虽然有人试图提出几个问题,但他们都有形状解决方案。



我认为你不能做到什么你想要,但肯定你需要找出它是否可能:我会尝试寻找一个ExcelProject类型的网站(如果有的话):这个网站上有一个QA设施:http://www.excel-formulas.com/ [ ^ ]这可能会对您有所帮助。我不知道他们是否收费 - 我从未使用过它们。
Ignoring the VBA part, I'm not sure you can do that at all - you can set a background for a sheet, and you can set a background for a shape, but I have never seen a way to add a cell background image in excel, and a quick google doesn't show up any way either - though there are a couple of queries from people trying to, they all have the "shape" solution.

I don't think you can do exactly what you want, but certainly you need to find out if it is possible at all: I'd try looking for a "ExcelProject" type site (if there is one): there is a QA facility on this one: http://www.excel-formulas.com/[^] which may help you. I have no idea if they charge or not - I've never used them.


这篇关于将图片放入单元格的背景中。不是整张纸的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆