how do I type over a pic on excel

[Shaun]

[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.

[Cutter]

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

[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.

In article <[email protected]>,
Cutter <[email protected]> wrote:

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

[Cutter]

You could link the text box to the cell containing the formula.

[CLR]

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

Vaya con Dios,
Chuck, CABGx3




"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
> In article <[email protected]>,
> Cutter <[email protected]> wrote:
>
> > What I do is to put a text box over the picture and format it with no
> > lines and no fill colour.