+ Reply to Thread
Results 1 to 3 of 3

Excel merged cell - can it automatically expand as text is typed?

  1. #1
    Joanne (JAS)
    Guest

    Excel merged cell - can it automatically expand as text is typed?

    I have merged two cells and want it to expand (get bigger) as more text is
    typed or added.

    I'm able to do this with just a single cell (row autofit, wrap text), but
    when I merge two or more cells, these options no longer work.

  2. #2
    RWN
    Guest

    Re: Excel merged cell - can it automatically expand as text is typed?

    I don't think you can and-in my opinion-it's just another reason to stay away from merged
    cells.

    --
    Regards;
    Rob
    ------------------------------------------------------------------------
    "Joanne (JAS)" <Joanne (JAS)@discussions.microsoft.com> wrote in message
    news:[email protected]...
    > I have merged two cells and want it to expand (get bigger) as more text is
    > typed or added.
    >
    > I'm able to do this with just a single cell (row autofit, wrap text), but
    > when I merge two or more cells, these options no longer work.




  3. #3
    JE McGimpsey
    Guest

    Re: Excel merged cell - can it automatically expand as text is typed?

    Take a look at the macro by Jim Rech:


    http://groups-beta.google.com/group/...programming/br
    owse_frm/thread/c681ec7915bee300/2601d8ed556c55e9?


    In article <[email protected]>,
    Joanne (JAS) <Joanne (JAS)@discussions.microsoft.com> wrote:

    > I have merged two cells and want it to expand (get bigger) as more text is
    > typed or added.
    >
    > I'm able to do this with just a single cell (row autofit, wrap text), but
    > when I merge two or more cells, these options no longer work.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1