Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put a text box in every cell?
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put a text box in every cell?
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put a text box in every cell?
If you need all the rows with text box to be the same height, you may want to
adjust the text box and row height to fit the text box with the most information before you select and copy your rows. "bmowell" wrote: 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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put a text box in every cell?
Can't you just use cells to contain the text?
- Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 5/31/2010 5:08 PM, 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to manually copy text from one cell to end of other text cell | Excel Discussion (Misc queries) | |||
Enter text in a cell to return a text value in same cell | Excel Discussion (Misc queries) | |||
Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
Copy text from cell to cell with one cell changing text | Excel Worksheet Functions | |||
New text added to cell AFTER current text in same cell | Excel Worksheet Functions |