Buying need help with google sheets, offering tbt for help

[Irelia]

I finished putting animated sprites of a bunch of pokemon in my spreadsheet last night, but when I refresh, the sprites shift down for some reason.

If you go beyond row 200, you'll see how they all shift down.
https://docs.google.com/spreadsheet...PXtVKGL6YN_k/edit?pref=2&pli=1#gid=1235613036

Does anyone know how to fix this? For some reason, all of the other animated sprites stay in place without moving..but these ones keep shifting/ moving. Also if I add a row above 201, somehow it all fixes but when I refresh the page, it goes back to normal.
if you can fix it, pm me your email and I'll give you permission to edit it. If you can fix it, I'll give 100 tbt

 

[ZetaFunction]

Anytime you insert a new row, the images (as far as I'm aware) won't move down, just the cell contents; so if you add a row, you'll have to manually move each sprite down into its proper slot. Unless you somehow figure out a macro that'll automatically move all the sprite down and into their slots when you add a row, I don't think there's an easy fix. It's why I try to avoid using images in spreadsheets, since they can't be 'confined' into a cell and moved around easily.

 

[Irelia]

Anytime you insert a new row, the images (as far as I'm aware) won't move down, just the cell contents; so if you add a row, you'll have to manually move each sprite down into its proper slot. Unless you somehow figure out a macro that'll automatically move all the sprite down and into their slots when you add a row, I don't think there's an easy fix. It's why I try to avoid using images in spreadsheets, since they can't be 'confined' into a cell and moved around easily.

Well even if I don't add/ delete a row, the contents keep moving down every time I refresh. Even if I fix it.
Oh well... I think I'll try inserting the pics a different way and see if that works out.