how do I type over a pic on excel

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
What I do is to put a text box over the picture and format it with n
lines and no fill colour
 
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.
 
How about putting a formula in a helper cell and linking it to the Text
box............

Vaya con Dios,
Chuck, CABGx3
 
Back
Top