How do I advance to next line when typing in the formula bar?

When typing in the formula bar in Excel - I want to be able to advance to the
next line (just as you would in Word). How do I do that? Pressng enter just
takes me to the next cell....

Alt/Enter
bob Umlas

"Penguin" <Penguin@discussions.microsoft.com> wrote in message
news:898B8E17-460F-42B2-A64E-4D58BC1A3C58@microsoft.com...
> When typing in the formula bar in Excel - I want to be able to advance to
the
> next line (just as you would in Word). How do I do that? Pressng enter
just
> takes me to the next cell....

Hold down the Alt keep and press Return, this will take you to a next line.

Or you can Format the cell to have Word Wrap, and then change the height of
the cell so when the text reaches the end off the cell it moves down.

"Penguin" wrote:

> When typing in the formula bar in Excel - I want to be able to advance to the
> next line (just as you would in Word). How do I do that? Pressng enter just
> takes me to the next cell....