Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Dec 2000
    Location
    Denver, CO
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell capacity (Excel 97 SR2)

    <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15> I'm trying to type a fairly long explanation into a cell (text). I understand the cell capacity is about 32,000 characters in Excel 97. However, I'm nowhere near that (i have about 1000 characters), and the text doesn't all show on the screen, nor will it print. I've tried the things I know, wrap text, making the cell larger--higher and wider--and the only thing that works is if I make it really wide. In fact, it only works if I go to the cell width limit of 255. But then, I have to make it so small to fit the page it is unreadable. I'd rather make it taller, but no matter how tall I go, it still cuts off the text, and I have a bunch of white space showing underneath where the cell cuts the text.
    Any ideas?

    Thanks, Rick

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

    Re: Cell capacity (Excel 97 SR2)

    Set your cell Alignment as Vertical: Top, and check Text Wrap, should show up to 1200 characters.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell capacity (Excel 97 SR2)

    Yes, a cell will hold a string of 32k bytes, but unfortunately Excel will only display and print about 1000 to 1200 characters. I don't know of a way around this, except to split the text into multiple cells. You can also put the text into a text box.
    Legare Coleman

  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: Cell capacity (Excel 97 SR2)

    Since my first answer was useless, I'll try another: you'll be able to get 32,000 characters and more into a text box and get it to print, along with the need to deal the special "abilities" of a text box (such as scrolling is a pain).
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    New Lounger
    Join Date
    Dec 2000
    Location
    Denver, CO
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell capacity (Excel 97 SR2)

    John, I don't understand this answer. Are you saying to use a text box? I thought of that except this workbook is something HQ sent out for us to complete and return. They will then combine my response with others across the country into one file. I don't think a textbox would work in this situation.

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

    Re: Cell capacity (Excel 97 SR2)

    Yes, I was suggestinga text box. If you have a designated format to comply with then I'm out of ideas ... unless you want to really annoy the home office ... in which case you need to write a 64,000 word response in Word, then embed it in Excel as an object! (Just kidding.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell capacity (Excel 97 SR2)

    If this is being imposed on you by the folks at HQ, why not email them and ask them how they want you to enter the information.
    Legare Coleman

Posting Permissions

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