When typing in a cell how do I get the text to drop down a line yet stay in the same cell?
ie. In word you hit enter and the cursor drops to the next line. In excel you hit enter and the next cell is selected.
When typing in a cell how do I get the text to drop down a line yet stay in the same cell?
ie. In word you hit enter and the cursor drops to the next line. In excel you hit enter and the next cell is selected.
Pedros, use Alt+enter to get a new line in the same cell
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Pedros" <Pedros.2b4dc8_1153189810.9561@excelforum-nospam.com> wrote in
message news:Pedros.2b4dc8_1153189810.9561@excelforum-nospam.com...
>
> When typing in a cell how do I get the text to drop down a line yet stay
> in the same cell?
>
> ie. In word you hit enter and the cursor drops to the next line. In
> excel you hit enter and the next cell is selected.
>
>
> --
> Pedros
> ------------------------------------------------------------------------
> Pedros's Profile:
http://www.excelforum.com/member.php...o&userid=28202
> View this thread: http://www.excelforum.com/showthread...hreadid=562306
>
thanks paul, much apprecitated!
![]()
![]()
![]()
your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Pedros" <Pedros.2b4eq8_1153191610.9097@excelforum-nospam.com> wrote in
message news:Pedros.2b4eq8_1153191610.9097@excelforum-nospam.com...
>
> thanks paul, much apprecitated!
>
>![]()
![]()
>
>
> --
> Pedros
> ------------------------------------------------------------------------
> Pedros's Profile:
http://www.excelforum.com/member.php...o&userid=28202
> View this thread: http://www.excelforum.com/showthread...hreadid=562306
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks