1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

extend the per cell character restriction in MS Excel

Discussion in 'Business Applications' started by jakerrr, Oct 5, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. jakerrr

    jakerrr Thread Starter

    Joined:
    Oct 5, 2008
    Messages:
    7
    Currently MS Excel 2007 has a restriction on it that only allows 255 characters to be entered into one cell. You can actually enter more for just storage, but they won't show up in the cell once you click off of it and you can't expand the cell large enough to make it fit any more of them.....it just cuts it off at 255. Try entering large bodies of text into a single excel cell and you'll see what I mean.

    Is there a way to extend or lift this restriction? We are trying to create a reporting form in excel and when people enter long descriptions in the form cell, it runs out of space.

    Thanks,
    John
     
  2. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Hi there John, welcome to the board!

    Why Excel? If it's a reporting form, or a form of any kind, why not use Word? I hate to say it, sometimes can't believe I say it, but maybe you should think about not using Excel.

    Also take a look here: http://www.mrexcel.com/forum/showthread.php?t=82691

    HTH
     
  3. jakerrr

    jakerrr Thread Starter

    Joined:
    Oct 5, 2008
    Messages:
    7
    I actually have been asked to make the form MS Word and questions of how to make word tables hold the same functionality as excel are in another post of mine. However, I already made it in excel, I just can't get around one problem......which is the limit on the amount of text you can enter into one cell. Actually, in my form it is more limited by row height than actual characters. So, maybe I should be asking you about how to get around the problem of row height limitations.

    Also, I read the forums at the link you gave me. They were insightful, but a little over my head.

    I've attached the form that I'm working with. F28 is the cell that I want to remove the limitations from so it can hold more text. Note that there is a blank form and an example one.

    Any more ideas are greatly appreciated.

    Thanks,
    John
     

    Attached Files:

  4. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Excel isn't made for what you're trying to do. You'd be much better off just creating it in Word. Shouldn't take too much more to do what you've done thus far. Make good use of form fields to help you. We can help you with that as well if you'd like.

    Have you ever thought of using InfoPath? You just need it to make the form, and to view you can use just a standard web browser (http://www.sharepointblogs.com/marwantarek/archive/2008/02/25/infopath-form-viewer-webpart.aspx).

    HTH
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/756310

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice