Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2004
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Text Wrapping (Excel 200)

    I am sure everybody is familiar with Text Wrapping. My problem is as follows: I want to know if there is any way that you can adjust the height of the cell automatically to display all the text in the cell. Failing that is there any macro code that I can link to a button that will expand the cell. I would be glad if anybody can assist me.

    Kobus
    Regards
    Kobus

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Text Wrapping (Excel 200)

    Format - cells - check "text wrap"
    Will have excel do it automatically if the cells are NOT "merged"

    If the cells are merged you have to use a macro to do it. If you are asking about text wrapping in merged cells check out <post#=270923>post 270923</post#> for some code and some of the other threads in it for more info. There have been several discussions on merge/wrap text so do a search in the lounge and you might be able to find more info.

    Steve

Posting Permissions

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