Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    L.A., California, USA
    Posts
    267
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Breaking rows across page boundary (Excel 2000)

    How do you get a row to break across a page boundary? We have a row with a large amount of text and it will not break across the page, leaving a big gap at the bottom of the prior page.

    Russ

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Breaking rows across page boundary (Excel 2000)

    Russ
    I don't know that it can be done.
    I tried using VBA to insert a pagefeed character into a string and that didn't work. I'm all out of any other ideas other than splitting the cell.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    L.A., California, USA
    Posts
    267
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Re: Breaking rows across page boundary (Excel 2000)

    Thanks, Andrew. I'm a total novice with Excel and I have to convert a large chart with several columns of text from MS Word to Excel. Someone here in the office found a small Excel manual, so at least I have a little help. It's really the kind of thing that works best in Word, but the client wants it in Excel, so guess who's "right"?

    Russ

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Breaking rows across page boundary (Excel 2000)

    Unless it is important that the text be all in one cell or row, split the text into two chunks and put them in separate consectutive rows. Ugly, but simple!
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    L.A., California, USA
    Posts
    267
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Re: Breaking rows across page boundary (Excel 2000)

    Thank you, John. It worked and helped save me tonight. Our firm does almost no Excel work, so none of us knows how to use it. Someone found a small Excel manual, so between it and the answers here, I'm getting through it.

    Russ

Posting Permissions

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