+ Reply to Thread
Results 1 to 5 of 5

cell text alignment

  1. #1
    Registered User
    Join Date
    04-14-2006
    Posts
    73

    cell text alignment

    I have a cell with 800-900 characters in it, all wrapped and centered. For some reason, the last line is no longer centered, but runs off the to the right of the cell so that the last few words are no longer visible. I haven't run into this before so I'm a little stumped as to why this is happening. If I widen out the cell enough, I can get it to all be visible, but this is problematic because it makes formatting for printing impractical for what I'm doing. Is there a way around this or am I going to have to reduce the number of characters in the cell?

  2. #2
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    Try cutting and pasting the cell to a spare cell, then copy a "good" cell into the problem cell, then paste back the original.

    Also if problem persists, delete the last 20 words and then retype them.

    May help...

  3. #3
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by racudd
    I have a cell with 800-900 characters in it, all wrapped and centered. For some reason, the last line is no longer centered, but runs off the to the right of the cell so that the last few words are no longer visible. I haven't run into this before so I'm a little stumped as to why this is happening. If I widen out the cell enough, I can get it to all be visible, but this is problematic because it makes formatting for printing impractical for what I'm doing. Is there a way around this or am I going to have to reduce the number of characters in the cell?
    Has the cell reached the maximum height of 409 points?

  4. #4
    Registered User
    Join Date
    04-14-2006
    Posts
    73
    Bryan,
    No, row height is about 236.

  5. #5
    Registered User
    Join Date
    04-14-2006
    Posts
    73
    I just counted - there are 1200 characters in the cell. Is this over the limit? And if so, is there a way to work around it without reducing the number of characters? I understand that you can see the cell contents in the tool bar, but I need to be able to print this information, so it must all be visible in the cell.
    Last edited by racudd; 09-29-2006 at 10:51 AM.

+ 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