Cell value on top, inside drawing
 

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

Cell value on top, inside drawing
 

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

"Revenue" wrote in message
...
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

Cell value on top, inside drawing
 

On Oct 26, 1:03*pm, "Cimjet" wrote:
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?

Cell value on top, inside drawing
 

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


On Wed, 26 Oct 2011 09:09:28 -0700 (PDT), Revenue
wrote:

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

Cell value on top, inside drawing
 

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"
wrote in message
...
On Oct 26, 1:03 pm, "Cimjet" wrote:
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?

Cell value on top, inside drawing
 

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)