Forum Discussion

Angelo_DZ's avatar
Angelo_DZ
Copper Contributor
Jan 27, 2022

EXCEL MICROSOFT 365 PROPERTY: "Move and Size with cells" is not behaving as expected

Hi,

I am using desktop version of Excel Microsoft 365.

 

I have included 2 objects in a worksheet: one text box and one rectangular shape.

 

https://revayassociates-my.sharepoint.com/:x:/g/personal/adizazzo_revay_com/EYHKKCZ2I4hEhEwaZBojmFMBuvwMx4Sf0ImI3vJv3e1Ffg?e=ht40Yt 

 

I want the objects to be able to both move and size with cells. So I have assigned the property "move and size with cells" to both objects.

 

If I apply a filter, the objects will size with cells. However, if I apply a sort, the objects won't won't move with with the cells. See attached workbook.

 

This is not behaving as expected, since the objects should move with the cells when the sort is applied. Am I doing something wrong, or is this a bug in Excel Microsoft 365? 

 

Thanks

excel

7 Replies

    • Angelo_DZ's avatar
      Angelo_DZ
      Copper Contributor
      Jan 27, 2022

      Hi Riny,

      Thanks for the advice.

      I inserted "x' on each column as you show in your screenshot, but when I select the whole area and sort the TASK column to "largest to small", the objects still don't move with the cells (see before and after screenshots below)

      I agree with your last comment that if I change the object properties to "move and don't size with cells", then the objects will move when the sort is applied.

      However, I want to have the objects to be able to both "move and size with cells" since I will be applying both sorts and filters in my actual working document that will contain many rows columns and many objects. I don't want to have to continually be changing object properties depending on my needs.

      Seems like there is a bug where the objects can't both move and size with cells despite having applied the proper property to "move and size with cells".

       

      Riny_van_Eekelen 

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jan 27, 2022

    Angelo_DZ You need to add a header to the columns that hold the objects, or select the entire range to be sorted. Now, when you sort the TASK column, Excel doesn't know that the columns towards the right are to be included also. Just put an "X" in each of the cells C17:N17 and give it a try.

     

    Edit: Set the objects to Move but not size, then it should work.

Resources