+ Reply to Thread
Results 1 to 5 of 5

Merging 2 cells

  1. #1
    Registered User
    Join Date
    04-16-2006
    Posts
    5

    Merging 2 cells

    I have the Swedish version of Excel so my translations may be wrong but...

    I mark 2 empty cells, rightclick and choose "Format cells..." but in the second tab for Adjustment, "Merge cells" are shadowed. Why?

  2. #2
    Ardus Petus
    Guest

    Re: Merging 2 cells

    Maybe your worksheet is protected?

    HTH
    --
    AP

    "d98rolb" <[email protected]> a écrit
    dans le message de
    news:[email protected]...
    >
    > I have the Swedish version of Excel so my translations may be wrong
    > but...
    >
    > I mark 2 empty cells, rightclick and choose "Format cells..." but in
    > the second tab for Adjustment, "Merge cells" are shadowed. Why?
    >
    >
    > --
    > d98rolb
    > ------------------------------------------------------------------------
    > d98rolb's Profile:

    http://www.excelforum.com/member.php...o&userid=33535
    > View this thread: http://www.excelforum.com/showthread...hreadid=533246
    >




  3. #3
    MartinW
    Guest

    Re: Merging 2 cells

    No if it was protected you wouldn't be able to select Format.

    When the check box is greyed out it usually means that one cell is already
    merged and the other is not. If you click on the grey tick it will brighten
    and merge all cells or click on it again and it will unmerge all cells.

    HTH
    Martin



  4. #4
    Registered User
    Join Date
    04-16-2006
    Posts
    5

    Merging 2 cells

    The checkbox for merge cells don't react on mouseclicks, it is always greyed. And the same apply whatever cells I select... But as a hint I notice that the menu Tool/Protect/Protect Sheet and workbook is also greyed.

  5. #5
    Registered User
    Join Date
    04-16-2006
    Posts
    5

    Smile Merging 2 cells

    Problem is solved, the worksheet was shared

+ 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