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?


Right-click on each image, and:
Excel picture menuExcel picture Size and Properties dialog box
(Tested in Excel 2007.)

| improve this answer | |

In excel 2010 its in a different place. Once you click on size and properties and go inside you have to click on properties then choose your object positioning

| improve this answer | |
  • 1
    This seems to be the exact same way as Scott already pointed out. Look at his picture – nixda Jul 12 '13 at 18:52
  • The UI is slightly different in 2010, but the instructions are the same. – Dane Jun 2 '14 at 18:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.