Microsoft Excel Tutorial – new feature to place a picture in a cell in Excel.
Can the Excel IMAGE function use a local hard drive? Not yet.
New Excel VBA method: InsertPictureInCell
Insert Many Pictures in Excel in one command.
Feature Requests:
Expose a VBA property to show original source of the image
Allow IMAGE function to point to local hard drive.
Allow Power Query to load in-cell images.
To download this workbook: https://www.mrexcel.com/youtube/mFd8HsHmfpA/
Table of Contents
(0:00) New Picture In Cell feature
(0:33) Pictures on drawing layer
(0:47) Inserting image in cell in Excel
(1:05) Fitting in Cell
(1:20) Alignment
(1:35) No apparent way to rotate image
(2:02) Use Case from Jerry
(3:48) Using VBA Macro Recorder
(4:11) Inserting 400 images
(4:36) VBA InsertPictureInCell
(4:53) Is there a VBA Property?
(5:07) Sorting images with cells
(5:39) Using a formula to refer to image
(6:00) File Size concerns
(6:30) Really need IMAGE formula for local drive
(7:04) Feature Request: Power Query support for images
(7:25) Wrap-up