Forum Discussion
Shapes do not move with cell when upper row is dleted
I have a line in a cell below a hidden row. When I delete any row above that in which there is the line the line does not move with cell.
Any idea why?
The default setting for shapes (in "Size and Properties") is: "depends on cell position only".
On the shape, right-click, format shape.
You have to change it to "independent of cell position and size".
*text has been translated.
Hope I could help you with these information.
I know I don't know anything (Socrates)
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
