View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bmowell bmowell is offline
external usenet poster
 
Posts: 2
Default How can I put a text box in every cell?

This works. But how do I get the height of my rows to adjust based on how
much info I have typed into my text box? Can I tie my row height to my
textbox height? I want to keep all rows in the row in question at the same
height based on whatever column contains the most information.

Thanks!

"marysully" wrote:

One way is to select the row with the text box and copy it to the next row.
Copy and paste it several times and then select the rows and paste them as a
group.

"bmowell" wrote:

Two questions:

-How can I put a text box in every cell that I am using WITHOUT having to
insert on manually every time?

AND

- How can I make sure that a text box inserts itself automatically into a
new row whenever I add a row?

Thanks!