Place Images Behind Cells/Text

**SambaGaz** · 10-02-2008, 08:23 AM

Hi

I want to place several images "behind" the cells or their text values - so if you imagine something like several different ID Cards for example, and I want to generate all the text for these using formulas and such, and place the text over specifc areas of the card images.

I can try to create a composite image of the various things I want and put them on a blank sheet adding it as a header/footer, but aligning everything, or making changes to the images make this a laborious task and not easily changeable.

Is there a simple way of adding images to an Excel (2007) worksheet and then moving it "behind" the cell contents (so the pictures do not mask the cell contents)?

Many thanks in advance

**MickG** · 10-02-2008, 08:59 AM

Hi, You could try Placing the Image in a cell, then place a Drawings "Text Box" above it , and set its transparecy to 100%.
Mick

**Andy Pope** · 10-02-2008, 09:37 AM

Can you edit the image and create transparent regions in it such that the cells show through?

**SambaGaz** · 10-06-2008, 11:51 AM

Thanks for the ideas guys...

I like the transparent image. That could work - although if I were to be picky, I'd prefer not to have a plain white background for the text boxes (or have to fiddle with cell properties to get them to match up to the rest of the image) - so I'll keep the thread open for now, but thanks again for the input!

Gaz