Hi,
I have an excel sheet, where I copy an image in every row, size it down, so it fits in one cell, and then set in Properties on Move and Size with Cells.
I have done this, because in the default case (Move but don`t size with cells) if I used a filter, fotos got displayed, even when they shouldn't have been there.
My problem is now, that after using different filters and then removing them I realized, that the pictures have been somehow (automatically by excel) copied to other cells too (the set properties are unchanged)
I have no idea why this happened, and I really want to prevent it to happen in the future.
Now there are so many pictures (because of making multiple copies automatically), that it takes a long time to open the sheet at all.
Can you help me, what the reason can be behind the multiplication of the fotos?
I don't know how to use macros, so I would prefer to find a solution without them.
Thanks for your help!
Bookmarks