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

%3CLINGO-SUB%20id%3D%22lingo-sub-3073464%22%20slang%3D%22en-US%22%3EEXCEL%20MICROSOFT%20365%20PROPERTY%3A%20%22Move%20and%20Size%20with%20cells%22%20is%20not%20behaving%20as%20expected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3073464%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20using%20desktop%20version%20of%20Excel%20Microsoft%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20included%202%20objects%20in%20a%20worksheet%3A%20one%20text%20box%20and%20one%20rectangular%20shape.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Frevayassociates-my.sharepoint.com%2F%3Ax%3A%2Fg%2Fpersonal%2Fadizazzo_revay_com%2FEYHKKCZ2I4hEhEwaZBojmFMBuvwMx4Sf0ImI3vJv3e1Ffg%3Fe%3Dht40Yt%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExcel%20file%3A%20move%20and%20size%20with%20cells%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20the%20objects%20to%20be%20able%20to%20both%20move%20and%20size%20with%20cells.%20So%20I%20have%20assigned%20the%20property%26nbsp%3B%22move%20and%20size%20with%20cells%22%20to%20both%20objects.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20apply%20a%20filter%2C%20the%20objects%20will%20size%20with%20cells.%26nbsp%3BHowever%2C%20if%20I%20apply%20a%20sort%2C%20the%20objects%20won't%20won't%20move%20with%20with%20the%20cells.%20See%20attached%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20not%20behaving%20as%20expected%2C%20since%20the%20objects%20should%20move%20with%20the%20cells%20when%20the%20sort%20is%20applied.%20Am%20I%20doing%20something%20wrong%2C%20or%20is%20this%20a%20bug%20in%20Excel%20Microsoft%20365%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3073464%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3073481%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20MICROSOFT%20365%20PROPERTY%3A%20%22Move%20and%20Size%20with%20cells%22%20is%20not%20behaving%20as%20expected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3073481%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1288316%22%20target%3D%22_blank%22%3E%40Angelo_DZ%3C%2FA%3E%26nbsp%3BYou%20need%20to%20add%20a%20header%20to%20the%20columns%20that%20hold%20the%20objects%2C%20or%20select%20the%20entire%20range%20to%20be%20sorted.%20Now%2C%20when%20you%20sort%20the%20TASK%20column%2C%20Excel%20doesn't%20know%20that%20the%20columns%20towards%20the%20right%20are%20to%20be%20included%20also.%20Just%20put%20an%20%22X%22%20in%20each%20of%20the%20cells%20C17%3AN17%20and%20give%20it%20a%20try.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEdit%3A%20Set%20the%20objects%20to%20Move%20but%20not%20size%2C%20then%20it%20should%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

 

Excel file: move and size with cells 

 

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

7 Replies

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

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

 

Angelo_DZ_0-1643293196576.png

Angelo_DZ_1-1643293332993.png

@Riny_van_Eekelen 

@Angelo_DZ Try the attached file.

 

Thanks. The blue box does not move when the sort is applied.
There is something wrong with excel. I have had this same issue in the past and then it got resolved, and now it is acting up again. I hope Microsoft product developers resolve this.

@Angelo_DZ I never touched the blue box. Set it also to Move but not size and it works. By the way, I can't help wondering why you want to have shapes with texts or a colour inside a cell. Why not just type the text in the cells and change the fill colour?

Thanks . I use shapes with colored fill to create some customized schedules in excel (Gantt charts) for demonstrative graphics. I find it simpler to edit the layout of the chart with drawn objects versus filling cells with color. But perhaps I should rethink my work process.