How to hide picture when hiding rows or columns in Excel?
Normally, when you hide columns or rows which contain a picture in a worksheet, the picture will be not hidden as following screenshot shown. How could you hide the picture when hiding rows or columns in Excel?
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
In fact, you can change the picture’s property to make the picture hiding with the rows or columns hidden, please do as follows:
1. Right clicking the picture that you want to hide when hiding the rows or columns, and then select Size and Properties from the context menu, see screenshot:
2. In the Format Picture pane, under the Size & Properties tab, select Move and size with cells option from the Properties section, see screenshot:
3. And then close the pane, now, when you hide columns or rows which with the picture, the picture will be hidden as well.
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 years agoHmmm. This works, in theory, but I'm finding that the images are being associated with the wrong rows (i.e. the image above or below hides, rather than the image within the hidden row). Any ideas?
To post as a guest, your comment is unpublished.· 1 years agoVery nice. Thank you.
To post as a guest, your comment is unpublished.· 1 years agoOddly, i can't get this to work with rows, but it works with columns.
Does anyone else have this issue in excel 2014?
To post as a guest, your comment is unpublished.· 2 years agoUnbelievable easy , so many time searching for solution.