Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2006
    Location
    Princeton, New Jersey, USA
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Wrap Text with Indent (Excel 2003)

    Hi Alll ... I searched the forum and can't find this. So, it probably can't be done.

    Is there a way (VBA is okay) to have text that wraps in a cell to indent on the all lines but the first one?

    Thanks,
    --cat

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

    Re: Wrap Text with Indent (Excel 2003)

    Excel doesn't have a 'hanging indent' feature such as Word has. Although it has some text formatting capabilities, it is not a full-blown word processor.

    If you want to emulate a numbered or bulleted list, you can do that by putting the numbers or bullets in a narrow column to the left of the column with the text:

    <table border=1><td align=right valign=top>1</td><td valign=top>This is the
    first item.</td><td align=right valign=top>2</td><td valign=top>This is the
    second item.</td></table>

  3. #3
    Star Lounger
    Join Date
    Mar 2006
    Location
    Princeton, New Jersey, USA
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wrap Text with Indent (Excel 2003)

    Thanks, Hans.

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 481 Times in 458 Posts

    Re: Wrap Text with Indent (Excel 2003)

    Hi Hans

    If you ever discover a direct solution to automating the 'hanging indent' issue I want it now.
    ..especially if the hanging indents could be in a different font size and colour.

    ..sometimes it's easier (but tedious) to do this manually in a cell by editing using [Alt][Enter] to force the text onto a 'hanging line', then using 'spaces' to create the indent, then highlighting the 'indented' text to change format and colour.

    ..hey, sometimes we can't use the column to the left and inserting a column could generate so many 'structure changes' to the worksheet that the manual option is our only realistic choice!

    ..but I live in hope that one day we will all get the features we want.

    zeddy

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

    Re: Wrap Text with Indent (Excel 2003)

    A hanging indent within a cell would be hell to program, especially if you want to update it automatically when the user changes the column width. Perhaps it could be done if you used a fixed-width font such as Courier New, but with a proportional font such as Times New Roman or Arial, it would be very very diffcult.

Posting Permissions

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