Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Shaun
 
Posts: n/a
Default how do I type over a pic on excel


  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Cutter
 
Posts: n/a
Default


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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Cutter
 
Posts: n/a
Default


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   Report Post  
CLR
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Opening two separate instances of Excel Ron Bishop Excel Discussion (Misc queries) 2 August 4th 05 05:30 PM
When I type 100 EXCEL changes it to 10. Why? Griff Excel Discussion (Misc queries) 2 May 19th 05 04:44 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
Excel: type "ACN" into a cell and you get "CAN" why? bacheb Excel Discussion (Misc queries) 3 January 11th 05 07:37 PM


All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"