 |
 | 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 / Worksheet Functions / May 2008Set up many cells within a cell
How to add cells within a cell? Thanks in advance. Please explain  SignatureBernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email > How to add cells within a cell? > > Thanks in advance. Hi Bernard, As in Word function, I want to divide an Excel cell into many cells so that add data without changing row. Thanks. > Please explain > > How to add cells within a cell? > > > > Thanks in advance. Cells cannot be split; they can be merged (Merge & Center tool) horizontally and vertically To get multiple lines of text (no border line in between) in one cell: type CAT, then ALT+ENTER, then DOG Hope this helps best wishes SignatureBernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email > Hi Bernard, > As in Word function, I want to divide an Excel cell into many cells so [quoted text clipped - 7 lines] >> > >> > Thanks in advance. A cell is defined as the intersection between a row and a column. [That's where the cell references come from.] You can't insert extra cells without inserting extra rows and/or columns. -- David Biddulph > Hi Bernard, > As in Word function, I want to divide an Excel cell into many cells so [quoted text clipped - 7 lines] >> > >> > Thanks in advance. As Word function I just want to split a cell into many cells so that I can add data without changing the row. Is it possible in Excel 2003? Thank you. > A cell is defined as the intersection between a row and a column. [That's > where the cell references come from.] [quoted text clipped - 13 lines] > >> > > >> > Thanks in advance. > As Word function I just want to split a cell into many cells so that I can > add data without changing the row. > Is it possible in Excel 2003? > > Thank you. As mentioned, you can't split/add cells without "changing the row". That's the same thing. If you have several items in one cell and want to split those to other cells, check out "Text To Columns" in the Data menu. Perhaps you didn't read what I said: "A cell is defined as the intersection between a row and a column. [That's where the cell references come from.] You can't insert extra cells without inserting extra rows and/or columns." Was it clearer that time? You can add data without extra cells. Alt+Enter will give a line break within a cell, if that's what you want. -- David Biddulph > As Word function I just want to split a cell into many cells so that I can > add data without changing the row. [quoted text clipped - 20 lines] >> >> > >> >> > Thanks in advance. |
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.