+ Reply to Thread
Results 1 to 7 of 7

Merge & Center only applies to last group of cells selected...

  1. #1
    Forum Contributor
    Join Date
    08-28-2015
    Location
    Montreal, Canada
    MS-Off Ver
    2013 on PC, 2011 on MAC
    Posts
    159

    Merge & Center only applies to last group of cells selected...

    I have no clue what caused this problem...

    Whenever I select multiple group of cells using CTRL (say B2:D2, then B3:D3, then B4:D4) and click on the 'Merge & Center' button on the ribbon, it only merges the last group of cells I selected (in this case, B4:D4). The other two groups are still highlighted as selected, but don't merge. It is working however if I use the drop-down arrow next to the 'Merge & Center' button, and use the 'Merge Cells' option...but it is very annoying.

    Any idea what may be the cause of my problem, and how to solve it ?

    Thanks.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Merge & Center only applies to last group of cells selected...

    Must be some sort of setting in the workbook maybe? I just tried it on mine using the same cells that you state in your post and it worked for all 3 groupings when I clicked Merge & center.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Contributor
    Join Date
    08-28-2015
    Location
    Montreal, Canada
    MS-Off Ver
    2013 on PC, 2011 on MAC
    Posts
    159

    Re: Merge & Center only applies to last group of cells selected...

    I looked through the options, I don't see anything about merging... :/

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Merge & Center only applies to last group of cells selected...

    Neither do I ....not sure what's going on then.

  5. #5
    Forum Contributor
    Join Date
    08-28-2015
    Location
    Montreal, Canada
    MS-Off Ver
    2013 on PC, 2011 on MAC
    Posts
    159

    Re: Merge & Center only applies to last group of cells selected...

    Thanks for taking the time to take a look, appreciated.

    Anyone else ?
    I guess re-installing could be an option, but I would hate to go through with that only to find out it was a simple checkbox hidden somewhere.

  6. #6
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Re: Merge & Center only applies to last group of cells selected...

    Have you tried merge across
    coz only merge and center will definately affect the activated pair of cells
    Teach me Excel VBA

  7. #7
    Forum Contributor
    Join Date
    08-28-2015
    Location
    Montreal, Canada
    MS-Off Ver
    2013 on PC, 2011 on MAC
    Posts
    159

    Re: Merge & Center only applies to last group of cells selected...

    Yeah, it works just fine whenever I use 'Merge across' or 'Merge Cells'. Even once they are merged, if I click on the 'Merge & Center' button to un-merge the same selected groups of cells, it works.

    But 'Merge and Center' to actually merge multiple different groups of cells doesn't work, eventhough it used to (and should). And I have no idea why...and it's been that way for all of my workbooks, so it's not specific to the one I'm running test on right now. :/

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Merge & Center random cells
    By coach.32 in forum Excel General
    Replies: 1
    Last Post: 02-26-2015, 03:53 PM
  2. [SOLVED] Join and Merge Selected Selected Cells
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2014, 06:54 PM
  3. Excel VBA: Merge and Center Cells Based on Date Values in Row Below
    By excelforumkeys in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2014, 11:23 AM
  4. [SOLVED] Merge and Center all cells within a border
    By rfaris in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-06-2013, 06:15 PM
  5. Allow Merge and Center in Formatted Cells
    By Mneubert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 03:45 PM
  6. Merge and Center Multiple Cells with the same data with a button click
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2012, 06:01 PM
  7. merge and center cells using macro
    By iscar_marius in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2009, 03:42 PM

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