Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Display.

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a spreadsheet with a comments heading in a column. Some comments can be upward of around 1500 charsacters (including spaces etc.). By merging and resizing the cells I can only get Excel to display around 1100 characters. Any ideas?

  2. #2
    Board Regular Corticus's Avatar
    Join Date
    Apr 2002
    Location
    Sarasota, FL
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I just tried putting about a million A's in a text box and inserting that in the sheet. Seemed to work pretty well...


    HTH,
    Corticus

  3. #3
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Nigel,

    I suggest you use a real comment rather than typing the comment in as the cell value. Once the data is entered into a cell comment you can scale the comment box to fit over the cell and a comment is not limited to displaying only 1024 characters. Insert the comment using menu Insert -> Comment, and keep it visible using View -> Comments.

    If you have lots of these, it would be fairly easy to write a VBA macro that automates moving and scaling all the comments and setting row height on a worksheet to display on top of the cells that contain them rather than displaying off to the side.
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have already tried that. Think of it as a very cell just 1 of many others that you can then use auto filter on etc. eg cell D1 has 1500 characters and cell D2 has 1100 characters etc.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry Damon my previous reply was to Corticus.

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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