Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I type over a pic on excel
|
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
What I do is to put a text box over the picture and format it with no lines and no fill colour. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=401182 |
#4
|
|||
|
|||
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 , Cutter wrote: What I do is to put a text box over the picture and format it with no lines and no fill colour. |
#5
|
|||
|
|||
You could link the text box to the cell containing the formula. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=401182 |
#6
|
|||
|
|||
How about putting a formula in a helper cell and linking it to the Text
box............ Vaya con Dios, Chuck, CABGx3 "JE McGimpsey" wrote in message ... 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 , Cutter wrote: What I do is to put a text box over the picture and format it with no lines and no fill colour. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
When I type 100 EXCEL changes it to 10. Why? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Excel: type "ACN" into a cell and you get "CAN" why? | Excel Discussion (Misc queries) |