Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    134
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Excel 2010 - Simulating numbered list within a cell

    I'm sure this has been addressed, but a quick search didn't bring anything up. I'm trying to create a numbered list within a cell. I know you can't do it like you do in Word, but what I am thinking is the next best thing is to manually type the numbers and tab over for the text. What I can't figure out how to do is get all of the lines in the list to line up under each other. Any easy way to do that?

    1. this would be item 1
    and would wrap like this
    2. this would be item 2
    and would wrap like this.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    If I understand the easiest way would be to have the numbers in 1 column and the text in the next. The text won't wrap under the numbers, but typically that is the preferred method. You can align all the text at the top so more text will wrap in the cell and make the row expand and the number will stay at the top.

    If you have to have it all in 1 cell, you will have to manually enter the numbers and then use <alt><enter> to add a linefeed in the cell to wrap at a given location.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    134
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks. I was trying to avoid the number in a separate column and keep it all in one cell for various reasons. I was pretty sure it couldn't be done, but I talked to someone who claims to have done it once but couldn't remember how. So I thought I would ask.

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    How about this:

    =ROW()&". "&"This is the text item wrapped."

    with the column width adjusted so that wrapping will cause the lines to be under the numbered item.

  5. #5
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,635
    Thanks
    115
    Thanked 649 Times in 592 Posts
    Caniac,

    You can create your numbered list in Word then copy it to Excel in the following manner,

    1. Copy the numbered list in Word
    1. Right click on the sheet where you want to paste and select Paste Special
    2. Select Microsoft Word Document Object> OK
    3. Right click the object's box and select format
    4, In the Color and lines tab, set Line color to "No Line" and Fill color to "No Fill"

    Indent.png

    HTH,
    Maud

  6. #6
    New Lounger
    Join Date
    Jun 2014
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If you are entering the items manually, then try using Alt Enter after each item and increase the width of the cell to ensure that you get the correct word wrap effect (making sure that word wrap is on, ofc).

    "item1 and would wrap like this
    item 2 and would wrap like this
    item 3 and would wrap like this"

    Hope that helps

  7. #7
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts
    I think putting together some of the suggestions in this thread (using Alt+Enter, wider columns) would be what you need. One addition: you can also include a &CHAR(nn) to concatenate a tab character (not sure what value of nn that is but that can be figured out). This will include some horizontal spacing if needed to align things on consecutive lines.

    Fred

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    The tab is char(9), but i do not believe a tab within a cell will do anything to the spacing.

    Steve

  9. #9
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,824
    Thanks
    135
    Thanked 482 Times in 459 Posts
    Hi Steve

    Another way could be to use formulas and Excel's camera tool.
    see example attached.

    zeddy
    Attached Files Attached Files

Posting Permissions

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