Jan 26 2022 09:09 PM
Jan 26 2022 09:09 PM
I am using desktop version of Excel Microsoft 365.
I have included 2 objects in a worksheet: one text box and one rectangular shape.
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?
Jan 26 2022 09:55 PM - edited Jan 26 2022 10:02 PM
@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.
Jan 27 2022 06:30 AM
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".
Jan 27 2022 06:57 AM
Jan 27 2022 07:07 AM
@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?
Jan 31 2022 06:19 AM