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

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

"Revenue" <(E-Mail Removed)> wrote in message
news:9d0fec2b-f7be-4211-b7d0-(E-Mail Removed)...
> 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

On Oct 26, 1:03*pm, "Cimjet" <cim...@newsgroup.org> 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?

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
<(E-Mail Removed)> 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

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" <(E-Mail Removed)>
wrote in message
news:f800eb06-3579-4dc5-9d45-(E-Mail Removed)...
On Oct 26, 1:03 pm, "Cimjet" <cim...@newsgroup.org> 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?

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)