how do I type over a pic on excel

J

JE McGimpsey

Unless you put the picture in the Background (Format/Sheet/Background),
in which case it will be tiled throughout the entire sheet, you can't
directly type over a picture because pictures "live" in the Drawing
layer above the cells.

You can make the picture transparent (Format/Picture) to see text in the
cells beneath.

You can also use the Camera Tool to create a linked picture of a cell
and position it on top of the other picture. Set the Fill to No fill,
and the border to No Line.
 
C

Cutter

What I do is to put a text box over the picture and format it with n
lines and no fill colour
 
J

JE McGimpsey

That works too. The only disadvantage vis-a-vis a linked picture is that
it's static, rather than allowing the results of a formula to be
displayed.
 
C

CLR

How about putting a formula in a helper cell and linking it to the Text
box............

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting a carriage return or something before a pic in a table cell so that I can show the border?? 1
How do I get text to write over pictures? 1
autoshapes & pictures 1
Drawing Objects and Pictures together in table cell: Layout change 1
excel, how do I print the contents of cells ON TOP of a picture? 0
How do I layer a animated pic over a flash slideshow? 7
Need help with Inserting background pic for letterhead 3
How do i fade the edges of a color filled text box? 1

Top