Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Split an Excel Table Cell? (XP)

    Hello,

    It seems from the F1 Help that you can only split a merged cell.
    Word has a snazzy option where you can split a table cell up into many rows.

    Can I do the same with Excel?

    Bob.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Split an Excel Table Cell? (XP)

    In Word, each row in a table can have a different number of cells, and can have a different width. In Excel, you are constrained to the grid of 65536 rows by 256 columns. There is no way to subdivide the basic units of this grid into smaller ones, you can only merge some of these units together.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split an Excel Table Cell? (XP)

    Thanks for that clarification.

    Bob.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split an Excel Table Cell? (XP)

    It depends by what yu mean by:

    <blockquote><hr>split a table cell up into many rows<hr></blockquote>

    If you want to put multiple lines of text into a cell so that it looks like the cell below, then you can do that.

    Select the cell where you want to do this. Select Cells from the Format menu. Click on the Alignment tab. Put a tick mark next to "Wrap text" and click OK. Now type the text into the cell and when you want to start a new line hold down the Alt. key and press Enter.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •