Share via

Can't do multiple columns or rows of cell merging (CTRL not working?)

Anonymous
2017-03-02T23:19:21+00:00

It appears that my ctrl button is not working only when I try to merge cells for multiple columns or rows.

I have a worksheet that contains info on packages I receive at my office:

Date received

Shipper's state

Shipper's name

Package weight

Package contents

Contents' quantities

etc.

When there are multiple items in one package, say five items, I'll enter the item one by one, and then merge the general info cells into one. So it would have one received date spanning five rows of cells (merged) with the five content items listed in the next row, each in its own cell (row).

I noticed that all of a sudden, I can't merge multiple clusters of cells at once.

I select the five rows I want to merge, press ctrl and do the same for another column, repeat a few more times,

but the only cells that merge are the last ones I've selected.

I've also noticed that I'm unable to select and drag to copy a formula.

I haven't updated my excel and no one's used my computer, but over the last 20 hours I'm being inconvenienced.

I've never had the merge problem before. As for the formula problem, I have "Enable fill.." checked under advanced options.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

22 answers

Sort by: Most helpful
  1. Anonymous
    2017-04-25T19:45:39+00:00

    Hi, the solution was that Microsoft updated the default operation of the merge button.

    If you look at the button, it has a small arrow pointing down.  Clicking that brings up other options.

    The third options is the behaviour you expect.

    Nothing to do with fixing Office.  They just messed with the operation for no apparent reason.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2017-05-19T20:24:26+00:00

    The best work around I have found so far is to add Merge Cells to the quick bar at the top of the screen for a single click solution.

    I still am bewildered as to why this was changed... seems like the worst possible decision to make.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2017-04-25T20:26:04+00:00

    I'm not sure, but it looks like you would have to build a Macro to do that. (https://answers.microsoft.com/en-us/office/forum/office\_2010-excel/ms-excel-2010-merge-default-settings/52b16eb6-1815-4371-9980-dff94d3ca2c8)

    I'll keep looking for another workaround. If I find one I'll post it here.

    -jb-

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2017-04-25T19:54:36+00:00

    Yep that does it Jared. Problem solved. Thank you so much!!!

    I'm sure MS has a valid reason for moving this operation as a sub-choice, but it seemed to work so much better before.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  5. Anonymous
    2017-03-10T09:56:03+00:00

    I'm having exactly the same issue.

    If I use CTRL to select multiple ranges to merge, it only merges the very last item selected.  The rest just stay as is or jump around with the formatting.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments