Forum Discussion
EXCEL MICROSOFT 365 PROPERTY: "Move and Size with cells" is not behaving as expected
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 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?