 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Lists in a cell
I need to put a list of names in a cell. It is cumbersome to use spaces to get to the next line. Is there a way that I can hit enter(or some other function) to move to a next line within the same cell. Thanks Bob To make a break within a cell press <Alt> and <Enter> Regards. Bill Ridgeway Computer Solutions >I need to put a list of names in a cell. It is cumbersome to use spaces to > get to the next line. Is there a way that I can hit enter(or some other > function) to move to a next line within the same cell. > > Thanks > Bob As per Bill's answer, however, a list in this format is generally indicative of bad spreadsheet design, as entries should really have their own cells.  SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- >I need to put a list of names in a cell. It is cumbersome to use spaces to > get to the next line. Is there a way that I can hit enter(or some other > function) to move to a next line within the same cell. > > Thanks > Bob |
Reply to this Message |
 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.