Writing Text Over Pictures

[Xenoun]

Hello, i'm having some trouble writing text(numbers) over a picture so that the text can be printed out on top of the picture.

If I insert a picture into excel it stays in front of any text and I can't write over it. So I looked up how to do this in excel and found out you can do it by inserting the picture in a header.

So I inserted the picture as a header, wrote over it and noticed that between the spreadsheet and print preview that the text is skewed from the picture. So I fixed this by moving text around and looking at print preview. Now with everything looking fine in print preview I hit print...The picture comes out looking as if its moved upwards on the page, whereas all the text stayed where it was in the preview. So i've gone back (after wasting a lot of paper) and moved the header picture down more with enter. It now looks like its cut off the page in print preview but prints fine...

Except the top half of my text is now missing in the print, yet is still displayed in print preview.

Does anyone know how to fix these issues properly? Is it the format somehow, or margins? I need the rest of my text to print, but it would be much better if how it looks in normal excel view is how it prints, instead of looking terrible but printing fine.

I also have access to an excel file which has used picutres that are inserted over the text, but only the outline of the picture is used and the "white, blank spaces" are invisible. This makes it so only the outline goes over the text, which is fine and the text isn't blanked out by the white spaces. Does anyone know how to do this as it would be perfect for me. I've had a hint that it may be something to do with the file type, but I haven't found anything.


Thanks for any help, from what i've seen a lot of people have problems with excel and pictures

 

[mikerickson]

If you create a rectangle and set both its fill and line transparency to 100%, the text you enter in that shape can be put over a picture.

Create a rectangle, right click on it to Enter Text and Format the Shape & Text

 

[Xenoun]

I don't think that really works for what I need. The text that needs to go over the picture is a lot of numbers. These numbers are automatically put in the correct position from data that is entered on another sheet. Typing into a rectangle doesn't give me cell references, and I can't automatically set the number in a rectangle to equal another cell.

From what i've seen it is possible to only keep the outline of a picture, and have the white spaces inbetween be 'invisible'. This way only the outline of the picture will go over the text. If anyone knows how to do this it would be perfect for what I need.

 

[Xenoun]

I've found a site that says the camera tool can be used to take a linked picture of a group of cells and then that picture can be placed over the top of another. Using the camera tool i've managed to place my text picture over the other picture and the text picture updates when my cells change