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]).
📚 RESOURCES
– 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
⌚ TIMESTAMPS
0:00 Introduction
0:43 Insert image function
1:53 Optional arguments
2:27 Source reference
3:28 Sort and filter images
3:55 Wrap up
📺 RELATED VIDEOS
– Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
📩 NEWSLETTER
– Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
– Official web site: http://www.kevinstratvert.com
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Discord: https://discord.gg/kHuujY2pZf
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert
– Instagram: https://www.instagram.com/kevinstratvert/
🎒 MY COURSES
– Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1
🙌 SUPPORT THE CHANNEL
– Hit the THANKS button in any video!
– Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel — the price to you is the same)
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert
source