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. Fabian357

    greyed out close button

    Fabian357, Nov 13, 2003, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    239
    Lady Layla
    Nov 13, 2003
  2. Thomi

    Print Preview Print Button Greyed Out

    Thomi, Apr 5, 2004, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    485
    Thomi
    Apr 5, 2004
  3. Guest

    Why is 'Compare and Merge Workbooks' greyed out?

    Guest, Oct 21, 2004, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    792
    Guest
    Oct 21, 2004
  4. M Zahedi

    greyed out button

    M Zahedi, Sep 15, 2005, in forum: Microsoft Excel Misc
    Replies:
    3
    Views:
    208
    M Zahedi
    Sep 15, 2005
  5. Guest
    Replies:
    1
    Views:
    278
    Guest
    Oct 12, 2005
  6. craig-o

    Merge Cell Button Greyed Out

    craig-o, Dec 14, 2005, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    1,068
    Dave Peterson
    Dec 14, 2005
  7. Guest
    Replies:
    4
    Views:
    429
    Guest
    Feb 20, 2006
  8. Guest

    Save button will not work- greyed out?

    Guest, Jun 19, 2006, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    469
    Guest
    Jun 19, 2006
Loading...