to place picture into cell's background. not whole sheet

Question

0.00/5 (No votes)

See more:

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

Posted 19-Jan-14 2:24am

Member 10533706

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-01-19T03:27:00

Solution 1

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.

Posted 19-Jan-14 3:27am

OriginalGriff

Comments

Member 10533706 19-Jan-14 10:47am

so you mean to find website with name like: ExcelProject ?
because there is not any

I will try put question on excelformulas, like you advised me. thanks for help.

I was in though, that maybe is posibel to it somehow via macros. Like change Spreadsheet size to one cell and place pic, then back resize to original. Is is stupid idea ?

OriginalGriff 19-Jan-14 10:51am

It's an alternative approach, certainly! But I don't think it'll work: have you tried it manually in an excel sheet?

Member 10533706 19-Jan-14 10:53am

no, it is just idea which came out now from my mind.
i'm totally programming newbie. i dont know code anything in visual basic.
i tried once Python, was not able to learn something

OriginalGriff 19-Jan-14 10:55am

Then start by ignoring programming completely, and get it working (if it's possible) in a spreadsheet directly. If you can't do it there, you probably can't do it at all.

Member 10533706 19-Jan-14 11:15am

yes but i dont know where to start. because spreadsheet thigs are kind of fixed. the idea was just blind shot.
would be awesome if here is someone who is using excel too

OriginalGriff 19-Jan-14 11:44am

Couple of us do (I do, for example) - but you need a true Excel Guru!
Someone who seems to know Excel pretty well is our resident accountant:
http://www.codeproject.com/Members/DalekDave
But he isn't normally active in QA (or when the pubs are open :laugh: )
You could try asking him if he'd mind you asking him a question via a reply to one of his messages in the Lounge (do *NOT* just ask the question there, you will get abuse if you do).

Member 10533706 19-Jan-14 11:57am

he doesnt know me. i'm just rand noob who came here today. may be if you know him.. just link him this topic and if he wil have time, he drop an eye ..

OriginalGriff 19-Jan-14 12:06pm

Done. Don't expect anything too soon - it's the weekend so he may not even get teh message til tomorrow - if he wants to answer that is! :laugh:

Member 10533706 19-Jan-14 12:23pm

i owe you.
ty v much

Member 10533706 21-Jan-14 11:26am

or i heard, it is possible to do in word.
so is possible to transfer my table to word, without any changes ? (my table is just merged cells in square cell grid
looks like this:
http://prntscr.com/2ladep

Member 10533706 2-Mar-14 13:35pm

codes this is not for my case ?
http://www.codeproject.com/Questions/659291/Set-Background-image-to-Cells-in-Excel

Member 10533706 5-Mar-14 13:52pm

anyone pls reply

is only way to do it in ms word ? (if possible ?)