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
rpgoldman's avatar
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'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

Resources