How to filter data with pictures in Excel?
Filter data with picture in Excel
|Kutools for Excel's Export Graphics can export or save pictures, charts, or shapes as png, tif, gif, jpeg in a folder|
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
To filter data with pictures, you only need to check the Move and size with cells option in the Format Pictures dialog.
|Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.|
1. Right click at the picture, and select Format Picture form the context menu. See screenshot:
2. In Excel 2013, a Picture Format pane is displayed, please click Size & Properties tab, next click Properties to expand the options, and check Move and size with cells. See screenshot:
Tip: If you are using Excel 2010/2007, in the Format Picture dialog, click Properties tab, and check Move and size with cells option in the right size.
3. Repeat above steps to check Move and size with cells option for every picture.
From now on, when you filter, the data and pictures will be filtered together.
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.· 21 days agoHow can I get this to work with objects in 2010? I have set all the objects on my page as Move and Size with cells, but when I filter, I get a bunch of overlapped shapes.
To post as a guest, your comment is unpublished.· 1 years agoIt worked! Thanks a lot!