In this step-by-step tutorial, learn how to insert images directly into cells in Microsoft Excel. Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort and filter, and work with images within an Excel table. This improvement unlocks and facilitates many new scenarios, such as tracking inventories, creating employee dashboards, or building games and brackets.
The IMAGE function inserts images into cells from a source location, along with alternative text. All you need to do is type the following into a cell: =IMAGE(source, [alt_text], [sizing], [height], [width]).
- Office Insider Blog Post on the Image Function: https://insider.office.com/en-us/blog/insert-images-in-cells-with-the-image-function-in-excel
- Get Microsoft 365: https://amzn.to/3KoYkvO
- Become an Office Insider: https://insider.office.com/en-us/join/windows
0:43 Insert image function
1:53 Optional arguments
2:27 Source reference
3:28 Sort and filter images
3:55 Wrap up