Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrap
Is it possible to wrap text to the next cell down?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrap
Hi,
Yes, but you need to merge the two cells. Suppose your text is in A1 and you want it the wrap to A2 Select A1:A2 and choose Merge & Center. Then choose Format, Cells, Alignment, and check Wrap Text. Change the center to left if you want. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "TimBCC" wrote: Is it possible to wrap text to the next cell down? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrap
Sure.
Stop typing at some point.............hit ENTER key then type some more in next cell. Seriously, Excel won't know when you have finished typing until you exit the cell in some manner........Enter........Tab.........Arrow out. You could get it done using event code but not without VBA Gord Dibben MS Excel MVP On Fri, 6 Mar 2009 14:00:00 -0800, TimBCC wrote: Is it possible to wrap text to the next cell down? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrap
Thanks for the responses. What I have is a "form" written in Excel. It was
originally made to print and fill out. I'm trying to tweak it so that you can just type in the lines on the computer (things like making check boxes actually check when you click them). I have it all figured out except for our 'Remarks' section on the "form". This section has six lines to it. Each line is a page in width (merged cells) and "underlined" by use of a border line. I was just trying to find an easy way to bump down to the next line while typing without having to hit enter, or merge columns, or creating a text box. Is this possible? Thanks for the help. "TimBCC" wrote: Is it possible to wrap text to the next cell down? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrap
I was just trying to find an easy way to bump down to the next line
while typing without having to hit enter, or merge columns, or creating a text box. Is this possible? Thanks for the help. Same response as my first reply. You must let Excel know you have finished entering data in that cell. Gord On Mon, 9 Mar 2009 04:55:01 -0700, TimBCC wrote: Thanks for the responses. What I have is a "form" written in Excel. It was originally made to print and fill out. I'm trying to tweak it so that you can just type in the lines on the computer (things like making check boxes actually check when you click them). I have it all figured out except for our 'Remarks' section on the "form". This section has six lines to it. Each line is a page in width (merged cells) and "underlined" by use of a border line. I was just trying to find an easy way to bump down to the next line while typing without having to hit enter, or merge columns, or creating a text box. Is this possible? Thanks for the help. "TimBCC" wrote: Is it possible to wrap text to the next cell down? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrap
Thanks for the replies guys. I was just trying to take the easy/lazy way out
by removing a step (hitting enter, down arrow, etc) to get to the next cell down while typing. I guess it can't be done. Again, thanks for the replies. Tim "Gord Dibben" wrote: I was just trying to find an easy way to bump down to the next line while typing without having to hit enter, or merge columns, or creating a text box. Is this possible? Thanks for the help. Same response as my first reply. You must let Excel know you have finished entering data in that cell. Gord On Mon, 9 Mar 2009 04:55:01 -0700, TimBCC wrote: Thanks for the responses. What I have is a "form" written in Excel. It was originally made to print and fill out. I'm trying to tweak it so that you can just type in the lines on the computer (things like making check boxes actually check when you click them). I have it all figured out except for our 'Remarks' section on the "form". This section has six lines to it. Each line is a page in width (merged cells) and "underlined" by use of a border line. I was just trying to find an easy way to bump down to the next line while typing without having to hit enter, or merge columns, or creating a text box. Is this possible? Thanks for the help. "TimBCC" wrote: Is it possible to wrap text to the next cell down? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get date/time to wrap (format - wrap text doesn't work)? | Excel Discussion (Misc queries) | |||
Wrap text doesn't wrap | Excel Worksheet Functions | |||
Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) |