Forum Discussion

pjflora's avatar
pjflora
Copper Contributor
Oct 29, 2021

"all the merged cells need to be the same size" during a Custom Sort

On ASUS StudioBook x64 PC, Windows 10 Pro for Workstations, ver. 20H2 (OS Build 19042.1288)Microsoft 365, EXCEL ver. 2109 (Build 1443020306) ...   While attempting to do a custom sort of an EXCEL t...
excel
char-glee23052023's avatar
char-glee23052023
Copper Contributor
May 23, 2023

rpgoldman I get the same thing on a Mac, did you ever figure out how to find merged cells through the find & select?

 

Also tagging pjflora to see if you can help

 

Thanks

rpgoldman's avatar
rpgoldman
Copper Contributor
May 23, 2023

char-glee23052023  No, I never figured this out.  Honestly, it's been so long since I asked that I have completely forgotten the context.

  • char-glee23052023's avatar
    char-glee23052023
    Copper Contributor
    May 23, 2023
    no worries thanks for replying anyway
    • eileenkenah's avatar
      eileenkenah
      Copper Contributor
      Nov 21, 2023

      char-glee23052023 

      On a MAC with office365 I highlighted all of the fields on my spreadsheet. I went to home and then clicked "Merge and Center" and then hit the dropdown "unmerge cells".

Resources