Excel Tips and Tricks - How to filter data with pictures?

Learn how to filter data with pictures in Excel.

In our daily work with Microsoft Excel, we typically filter data based on particular criteria to only display the data we want. However, if there are images/pictures present alongside the values, Microsoft Excel's filter function will only remove the images from the data. This video, I will explains how to use Microsoft Excel's combined picture and data filtering feature.

1) Select any of the pictures.
3) Ctrl + A
4) Right-click on any picture.
5) Select Format Object.
6) Select Size and Properties
7) Expand Properties
8) Select Move and size with cells.

*** Pokemon data From this webpage ***
https://bulbapedia.bulbagarden.net/wiki/List_of_Pok%C3%A9mon_by_base_stats_(Generation_VIII-present)

excel images not sorting,select all pictures in excel,how to lock images in excel when filtering,multiple picture lookup in excel,how to filter images in excel,excel image function,how to sort images in excel,how to unlock picture in excel,


#microsoft #excel #exceltips #tips #exceltricks #tricksandtips