Cell value on top, inside drawing

[Revenue]

Using the drawing tools, I made a box to go on a printed form. See the
link below for the actual box. In the cells that this box is in, how
do you make Excel allow you to put in any text or values and have it
show up as if it fits in the boxes properly. The drawing box stays on
top and you can type whatever you want in the tell, but nothing will
be visible.

http://www.filedropper.com/box_2

 

[Cimjet]

Hi
You should use the Text Box in the drawing tools, then you can type anything in
it.
Cimjet

 

[Revenue]

Hi
You should use the Text Box in the drawing tools, then you can type anything in
it.

That wouldn't work because I need a formula in there which will change
each month. The result of the formula would appear in roughly 28
different cells, so I definitley would not want to type it in each
month.

Any other ideas?

 

[Gord Dibben]

Select some cells and place thick borders around them.

Type in what you want.

Place a 100% transparent drawing rectangle over those cells.

Move it out of the way when you want to re-type in the cells.


Gord

 

[Jim Cone]

A possible option... http://www.filedropper.com/boxr1
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(Extras for Excel add-in: convenience built-in)



"Revenue" <[email protected]>
wrote in message

Hi
You should use the Text Box in the drawing tools, then you can type anything in
it.

That wouldn't work because I need a formula in there which will change
each month. The result of the formula would appear in roughly 28
different cells, so I definitley would not want to type it in each
month.

Any other ideas?

 

[Jim Cone]

And this one even works... http://www.filedropper.com/boxr2
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)