A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can I put a text box in every cell?



 
 
Thread Tools Display Modes
  #1  
Old May 31st, 2010, 10:08 PM posted to microsoft.public.excel.misc
bmowell
external usenet poster
 
Posts: 10
Default 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  
Old May 31st, 2010, 10:29 PM posted to microsoft.public.excel.misc
marysully
external usenet poster
 
Posts: 95
Default 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  
Old May 31st, 2010, 10:59 PM posted to microsoft.public.excel.misc
bmowell
external usenet poster
 
Posts: 10
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!

  #4  
Old June 1st, 2010, 01:01 AM posted to microsoft.public.excel.misc
marysully
external usenet poster
 
Posts: 95
Default 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  
Old June 1st, 2010, 06:14 PM posted to microsoft.public.excel.misc
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default 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!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.