Forum Discussion

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...

Sample set.xlsx36 KB

excel

rpgoldman

Copper Contributor

Sep 28, 2022

pjfloraWhen I try to do this on a Mac, using Office365's Excel, there is no option to find formats. I have an image for this, but Tech Community won't let me upload it. The options on the Find pop up are only "Within:" "Search:" and "Look in:"

Within is sheet or book; search is by rows or columns, and look in offers "formulas," "values," "notes," and "comments."

Is there another way to find merged cells?

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
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
  Copper Contributor
  May 23, 2023
  no worries thanks for replying anyway
  - 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".