Cell value on top, inside drawing

R

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
 
C

Cimjet

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

Revenue

Hi
You should use the Text Box in the drawing tools, then you can type anything in
it.
Click to expand...
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?
 
G

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
 
J

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.
Click to expand...
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
What’s the best way to automatically update dimensions on a drawing image imported from a jpg to Exc 1
Unrecoverable drawing on a word document 0
Easy way to select pasted EMF in Drawing Canvas containing text box 0
Text boxes moving to Cell A1 on top of each other after turning off AutoFilter 7
How can i locate the Drawing Tool Bar so it stays on the screen 0
Drawing layer does not print with document 3
ZOrder Behavior Changed in Excel 2007? 2

Top