How to stick an embedded document in a specific cell of an excel

Question

I have embedded a few documents in a few designated cells of my excel sheet. These embedded documents often migrate from their cell if I apply a filter or change the size of any other row in the spreadsheet.

To rearrange them is really annoying. Is there a way to make these documents adhere to certain cells and guarantee that they stay there regardless of the formatting applied?

Answer 1

1. Select the documents (you can use the "Select Objects" functionality in the Home tabs "Find&Select" dropdown if you have a lot:

   )

2. Go to the "Format Object..." dialog (right mouse click on any document - or Ctrl-1)

3. In the "Properties" tab, select "Move and size with cells":