Forum Discussion
Shapes do not move with cell when upper row is dleted
Thanks for your reply. I could not find "depends on cell position only".
or "independent of cell position and size" (vide below snapshot of the "Size and properties"menu)
I am using Microsift 365.
click on "Don't move or size with cells".
I removed the caption from Excel 2016 in the previous text and quickly translated it myself from German to English...whatever click on "Don't move or size with cells".
After that delete the top cells from the shape and you will see that it doesn't move with the cell.
Since I have the feeling that we are exchanging views on different things...
If I may recommend, attach a file or photo and use this file or photo to explain your topic in more detail, if possible step by step. It would be advantageous to know the information about the Excel version (like now), operating system and storage medium.
Thank you for your understanding and patience
- Mario3651260Aug 11, 2022Copper Contributor
Can't because the below happens: if shape is formatted as you suggested:
Before row deletion:
After row deletion:
- NikolinoDEAug 11, 2022Gold ContributorUnfortunately, I can't make sense of these photos, I can't understand where the error should be. Could you please help me and be a little more specific?
...need a little more help to understand 🙂- Mario3651260Aug 11, 2022Copper Contributor
The problem is as follows:
In the fig above, if I delete any row above the shape (eg row 841), the below image is the result. This only happens if the row immediately above that in which there is the shape is hidden(i.e. 0 height)