Forum Discussion
Angelo_DZ
Jan 27, 2022Copper Contributor
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/perso...
Riny_van_Eekelen
Jan 27, 2022Platinum Contributor
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.