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
 
You must log in or register to reply here.

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

how do i get a pic installed on the background and type on it 3
One sunset pic 6
Houses with Xmas lights from iphone 12 1
A negative display watch 9
Windows 7 Cannot retrieve pics from cd 4
Word Tilde over X 7
Excel How to Fix Damaged Excel File That Won't Open? 3
How to place a url or pic in a cell 2

Back
Top