In Add-in A-Tools allows you Insert pictures fit to cells in selection very easy in Excel. You can use function BS_PIC if you want to display dynamic image in sheet...
Follow the steps:
1. Select many cells in sheet that you want to display pictures
2. Goto menu A-Tools -> Advanced Input -> Get multple pictures...
A-Tools display dialog ask you insert picture or get link?
Click Yes to display pictures
Click No to get links