Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

End line within a cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave - 03 Mar 2008 19:20 GMT
Hi all, When I apply text wrap to a cell, the width of the column
determines how the wrap is handled. I want to have a short list in one
cell, and start new lines within the cell for each item in the list. I
have discovered that if I write the list in Word, then paste it into
Excel, I can achieve this, but I haven't discovered how to insert an
end-line thingy within the cell text directly in Excel Is it possible?
Regards - Dave.
Ron Coderre - 03 Mar 2008 19:23 GMT
Try this:
When editing the cell...ALT+ENTER...inserts a line feed, forcing the text to
wrap.

Does that help?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

> Hi all, When I apply text wrap to a cell, the width of the column
> determines how the wrap is handled. I want to have a short list in one
[quoted text clipped - 3 lines]
> end-line thingy within the cell text directly in Excel Is it possible?
> Regards - Dave.
Dave - 03 Mar 2008 19:59 GMT
Hi Ron, Thanks. Just what I wanted. Should I have been able to find
that in the Help somewhere?
Dave.

On Mar 3, 4:23 pm, "Ron Coderre" <ronREMOVETHIScode...@bigfoot.com>
wrote:
> Try this:
> When editing the cell...ALT+ENTER...inserts a line feed, forcing the text to
[quoted text clipped - 19 lines]
>
> - Show quoted text -
Ron Coderre - 03 Mar 2008 20:05 GMT
I'm glad I could help.

To answer your question:
Search help for "keyboard shortcuts"
ALT+ENTER is in the "Keys for entering, editing, formatting, and calculating
data" section.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Hi Ron, Thanks. Just what I wanted. Should I have been able to find
that in the Help somewhere?
Dave.

On Mar 3, 4:23 pm, "Ron Coderre" <ronREMOVETHIScode...@bigfoot.com>
wrote:
> Try this:
> When editing the cell...ALT+ENTER...inserts a line feed, forcing the text
[quoted text clipped - 24 lines]
>
> - Show quoted text -

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.