Forum Discussion
Excel - Image Disappearing
The images are probably only dependent on the cell position.
For a filter, the images must be dependent on cell position and size.
Procedure:
Select all images - format graphic - properties - dependent on cell position and size
Hope I could help you with these information.
I know I don't know anything (Socrates)
Thanks for your response NikolinoDE ,
These are the properties of the images in which I have "Move and size with cells" selected (highlighted in yellow) which is perhaps what you are talking about when you say "images must be dependent on cell position and size"
Filtering the data works fine, the images act as text when filtering, however when I want to delete the rows, for example: all except 1's from column A using a filter, then un-filtering column A to show what is left (which would be the 2's) the images corresponding for each rows for those 2's disappear.
Unfortunately, I cannot understand your plan, my knowledge is not so well developed that I can infer your plan from the picture and your text.
It would be an advantage to let us know your Excel version, operating system, storage medium, possibly also the image format.
At the same time, I recommend including a fileMaximum size: 71 MB • Maximum attachments allowed: 5)...or pictures that can show what you intend to do.
Based on this file/image, you explain your project step by step, so you can come up with a solution much faster and more accurately.
Thank you for your patience and understanding
- Thanks for the quick reply NikolinoDE,
I tried doing the same procedure just today and for some reason, excel just decided to work properly. My issue is now fixed. Thank you so much for taking your time to try and help me solve my problem.
I edited the post so perhaps you can have a better idea of the problem.
Thanks!Thank you for your feedback and the images.
That's where murphy's law crept in 🙂
I'm glad that your problem has been fixed and I wish you continued success with Excel.