Merge button greyed out

Discussion in 'Microsoft Excel Misc' started by Guest, May 15, 2007.

  1. Guest

    Guest Guest

    I want to merge two cells. I select them, but the merge button, and the merge
    option in the format/cells/alignment dialog box are greyed out. Why?!!!
     
    Guest, May 15, 2007
    #1
    1. Advertisements

  2. Is the worksheet protected?

    Is the workbook shared?

    Chris Hughes wrote:
    >
    > I want to merge two cells. I select them, but the merge button, and the merge
    > option in the format/cells/alignment dialog box are greyed out. Why?!!!


    --

    Dave Peterson
     
    Dave Peterson, May 15, 2007
    #2
    1. Advertisements

  3. Guest

    Gord Dibben Guest

    That is a good problem.

    Merged cells cause no end of problems with sorting, copying, pasting, filtering
    and a host of other functions.

    Maybe Center across selection would work for you if you are merging cells
    horozontally?

    See Dave's post for possible sources for the grayed-out merge.


    Gord Dibben MS Excel MVP

    On Tue, 15 May 2007 04:36:00 -0700, Chris Hughes
    <> wrote:

    >I want to merge two cells. I select them, but the merge button, and the merge
    >option in the format/cells/alignment dialog box are greyed out. Why?!!!
     
    Gord Dibben, May 15, 2007
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Milo
    Replies:
    0
    Views:
    322
  2. Guest

    Why is 'Compare and Merge Workbooks' greyed out?

    Guest, Oct 21, 2004, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    704
    Guest
    Oct 21, 2004
  3. Guest
    Replies:
    1
    Views:
    209
    Guest
    Oct 12, 2005
  4. craig-o

    Merge Cell Button Greyed Out

    craig-o, Dec 14, 2005, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    1,008
    Dave Peterson
    Dec 14, 2005
  5. Guest
    Replies:
    4
    Views:
    356
    Guest
    Feb 20, 2006
Loading...

Share This Page