+ Reply to Thread
Results 1 to 5 of 5

Can't merge cells, unless including the A column

  1. #1
    Registered User
    Join Date
    11-21-2023
    Location
    Amsterdan
    MS-Off Ver
    2310
    Posts
    3

    Can't merge cells, unless including the A column

    Microsoft Excel for Microsoft 365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit.

    I have a brand new spreadsheet, no data, no macros, no plug-ins. Spreasheet is not protected nor shared.

    I want to merge cells B1 and C1. When I select both cells, on the Home tab, in the Alignment section, I click the Merge & Center drop down, and click Merge & Center, or Merge Across, or Merge Cells, the cells are not merged.

    But when I try to merge cells A1 + B1, or A1 + B1 + C1, or A1 + B1 + C1 + D1, the cells are successfully merged.
    A2 + B2, or A2 + B2 + C2, can also be successfully merged. But B2 + C2 cannot, nor can C2 + D2.

    As long as a cell from the A column is included, the merge is successful. If the A column is excluded from the merge, the merge is never successful.

    Running on Windows 10 Enterprise, 22H2, build 19045.3693 .

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,673

    Re: Can't merge cells, unless including the A column

    Welcome to the Forum ArtVandelay2020!

    First virtually all Excel experts advise against merging cells.

    I have never heard of this behavior before. Do have you add-ins installed?

    I know you said it's a new file, but maybe attach it here just to humor me.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-21-2023
    Location
    Amsterdan
    MS-Off Ver
    2310
    Posts
    3

    Re: Can't merge cells, unless including the A column

    There's literally nothing in the file. I close it without saving, open a brand new blank workbook, and can repeat the behavior every time.

    There are no active application add-ins.
    Last edited by ArtVandelay2020; 11-21-2023 at 04:30 PM.

  4. #4
    Registered User
    Join Date
    11-21-2023
    Location
    Amsterdan
    MS-Off Ver
    2310
    Posts
    3

    Re: Can't merge cells, unless including the A column

    OK, now that I test it again, merging works just fine. I haven't rebooted; can't explain what might have changed, but it must have been a local memory issue. Sorry about the wasted time.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,673

    Re: Can't merge cells, unless including the A column

    No trouble at all. If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

+ 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] Average, but only including certain cells based on text in different column
    By debora in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-26-2022, 06:58 AM
  2. Merge cells in a column, using a column as a reference to merge them
    By mattybNSI126 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-20-2018, 06:05 PM
  3. Merge cells from multiple workbooks (including comboboxes)
    By wattomusic in forum Excel General
    Replies: 1
    Last Post: 01-24-2018, 10:59 PM
  4. [SOLVED] finding min in column including blank cells??
    By m77wls in forum Excel General
    Replies: 16
    Last Post: 07-24-2015, 08:25 AM
  5. Merge 3 cells into 1 including . and @
    By ProMonkey in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-17-2014, 06:08 AM
  6. Sum of a column including blank cells
    By Jacktenforty in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-20-2014, 04:02 PM
  7. Add a column without including the last 3 cells
    By nachousa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2010, 04:35 PM

Tags for this Thread

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