I have a text box and cannot use the Enter key to seperate lines
 

In a Text Box in Excel 2007, when I press the "Enter" key it does not work????

Answer: I have a text box and cannot use the Enter key to seperate lines
 

I understand your frustration with this issue. By default, when you press the "Enter" key in a text box in Excel, it will simply move the cursor to the next cell. However, there is a simple workaround to allow you to add line breaks within a text box.

1. Double-click on the text box to activate it.
2. Click where you want to insert a line break.
3. Hold down the "Alt" key on your keyboard.
4. While holding down the "Alt" key, press the "Enter" key on your keyboard.

This will insert a line break within the text box. You can repeat this process to add additional line breaks as needed.

Alternatively, you can also use the "Wrap Text" feature to automatically wrap text within a text box. To do this:

1. Double-click on the text box to activate it.
2. Click on the "Format" tab in the ribbon at the top of the screen.
3. Click on the "Wrap Text" button in the "Text Box Styles" group.
4. Your text will now automatically wrap within the text box as you type.

I hope this helps you with your issue.

I have a text box and cannot use the Enter key to seperate lines
 

whether it's a textbox in a userform or on the sheet, you have to
program it to do what you want it to. all by itself it doesn't do
anything. what do you want it to do when you hit "enter"?
susan



On Oct 21, 8:15*am, Geechee wrote:
In a Text Box in Excel 2007, *when I press the "Enter" key it does not work????

I have a text box and cannot use the Enter key to seperate lines
 

from a post in excel.programming:

To get the Enter key to take you to the next line in a
textbox (where MultiLine = True), set the EnterKeyBehavior
property to True.

maybe this is what you want.
susan


On Oct 21, 8:15*am, Geechee wrote:
In a Text Box in Excel 2007, *when I press the "Enter" key it does not work????

I have a text box and cannot use the Enter key to seperate lin
 

How do I get to place where I select "True"

Thanks.

"Susan" wrote:

from a post in excel.programming:

To get the Enter key to take you to the next line in a
textbox (where MultiLine = True), set the EnterKeyBehavior
property to True.

maybe this is what you want.
susan


On Oct 21, 8:15 am, Geechee wrote:
In a Text Box in Excel 2007, when I press the "Enter" key it does not work????

I have a text box and cannot use the Enter key to seperate lin
 

you have to toggle "design mode" - it's a toolbar button that has a
triangle, pencil & ruler on it. once that is pressed, you can right
click the toolbar & click on "properties".
find "multiline" and change that to true.

the design mode button is on the control toolbox toolbar - you can
find that toolbar (if you don't already have it visible) by right
clicking up in your toolbars and choosing "control toolbox".
:)
susan


On Oct 21, 9:44*am, Geechee wrote:
How do I get to place where I select "True"

Thanks.



"Susan" wrote:
from a post in excel.programming:

To get the Enter key to take you to the next line in a
textbox (where MultiLine = True), set the EnterKeyBehavior
property to True.

maybe this is what you want.
susan

On Oct 21, 8:15 am, Geechee wrote:
In a Text Box in Excel 2007, *when I press the "Enter" key it does not work????- Hide quoted text -

- Show quoted text -

I have a text box and cannot use the Enter key to seperate lin
 

I'm looking at the top of my spreadsheet and can't find the toolbar button
anywhere.... I know it's there somewhere but just frustrated that a simple
thing like working in a Text Box has been made so difficult.....

Thanks.

"Susan" wrote:

you have to toggle "design mode" - it's a toolbar button that has a
triangle, pencil & ruler on it. once that is pressed, you can right
click the toolbar & click on "properties".
find "multiline" and change that to true.

the design mode button is on the control toolbox toolbar - you can
find that toolbar (if you don't already have it visible) by right
clicking up in your toolbars and choosing "control toolbox".
:)
susan


On Oct 21, 9:44 am, Geechee wrote:
How do I get to place where I select "True"

Thanks.



"Susan" wrote:
from a post in excel.programming:

To get the Enter key to take you to the next line in a
textbox (where MultiLine = True), set the EnterKeyBehavior
property to True.

maybe this is what you want.
susan

On Oct 21, 8:15 am, Geechee wrote:
In a Text Box in Excel 2007, when I press the "Enter" key it does not work????- Hide quoted text -

- Show quoted text -

I have a text box and cannot use the Enter key to seperate lin
 

oh yeah, you said you have excel 2007. i don't know where the
toolbars are in 2007..........

http://groups.google.com/group/micro...384fe09eb88d80

try this thread.
susan


On Oct 21, 10:18*am, Geechee
wrote:
I'm looking at the top of my spreadsheet and can't find the toolbar button
anywhere.... * *I know it's there somewhere but just frustrated that a simple
thing like working in a Text Box has been made so difficult..... *

Thanks.



"Susan" wrote:
you have to toggle "design mode" - it's a toolbar button that has a
triangle, pencil & ruler on it. *once that is pressed, you can right
click the toolbar & click on "properties".
find "multiline" and change that to true.

the design mode button is on the control toolbox toolbar - you can
find that toolbar (if you don't already have it visible) by right
clicking up in your toolbars and choosing "control toolbox".
:)
susan

On Oct 21, 9:44 am, Geechee wrote:
How do I get to place where I select "True"

Thanks.

"Susan" wrote:
from a post in excel.programming:

To get the Enter key to take you to the next line in a
textbox (where MultiLine = True), set the EnterKeyBehavior
property to True.

maybe this is what you want.
susan

On Oct 21, 8:15 am, Geechee wrote:
In a Text Box in Excel 2007, *when I press the "Enter" key it does not work????- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -