Ok, so I am using Microsoft Excel 2010 and have a set up currently where I have 2 views expanded and deflated using the Group or +/- function. My problem is that the UI has images on the workbook, too. The images are over the cells which are to be "hidden" when the - button is pressed and I would like the images to disappear with them. This is not curently happening, instead they are moving to the next visible cell. I have included an example below in case I wasn't clear.
I wish to hide Columns M:AU and the images are in various cells, such as N5 and O5. When I collapse (hide) the column range, all of the images move to AV5, the next row along that isn't hidden. This means the workbooks are looking messy when collapsed which is the opposite of what I was trying to do. Can anyone advise on a way around this?
Best Answer
Right-click on each image, and:
(Tested in Excel 2007.)