+ Reply to Thread
Results 1 to 3 of 3

Wrap and merge text will not show all lines

  1. #1
    jar57
    Guest

    Wrap and merge text will not show all lines

    I am using a required formate for a report done in Excel. The odd lines use
    5 blocks and the even lines use these blocks merged into one to fill with
    text. When the data is 9 or more lines long it quits wrapping so cannot be
    read.

    My report is due and I cannot figure out how to fix this. Any ideas or is
    this a program problem?

  2. #2
    Jim Rech
    Guest

    Re: Wrap and merge text will not show all lines

    Text does stop wrapping in a cell after about 1000 characters. You might
    consider putting the text in a text box (from the Drawing toolbar).

    --
    Jim
    "jar57" <[email protected]> wrote in message
    news:[email protected]...
    |I am using a required formate for a report done in Excel. The odd lines
    use
    | 5 blocks and the even lines use these blocks merged into one to fill with
    | text. When the data is 9 or more lines long it quits wrapping so cannot
    be
    | read.
    |
    | My report is due and I cannot figure out how to fix this. Any ideas or is
    | this a program problem?



  3. #3
    Dave Peterson
    Guest

    Re: Wrap and merge text will not show all lines

    Try adding some alt-enters (to force new lines within the cell) every 80-100
    characters. You'll see more characters. (You may have to resize the rowheight,
    though.)

    jar57 wrote:
    >
    > I am using a required formate for a report done in Excel. The odd lines use
    > 5 blocks and the even lines use these blocks merged into one to fill with
    > text. When the data is 9 or more lines long it quits wrapping so cannot be
    > read.
    >
    > My report is due and I cannot figure out how to fix this. Any ideas or is
    > this a program problem?


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1