Excel 2024: Place Pictures In Cell From Local Computer


April 15, 2024 - by

Excel 2024: Place Pictures In Cell From Local Computer

For the last 30 years, you could use Insert, Picture in Excel. The image was added to a special drawing layer that floated above the grid. In June of 2023, that legacy experience became known as Place Over Cells. The new experience is to Place In Cell.

Here is a great use for Place In Cell. Arrange several photos in a folder on your computer. Insert a new picture worksheet in your computer. From a blank cell B4, use Insert, Picture, Place In Cell, This Device. If you specify several images, they will be arranged in a column.

This step is important. Right-click the first image and choose View Alt Text. An Alt Text pane will appear on the right side of the screen. Type some Alt Text for the image. With the Alt Text panel still showing, click the next image and type Alt Text for that image. Repeat for each image.

continue reading »

More Reading


Excel 2024: Display Online Pictures In a Cell Using a Formula

Excel 2024: Display Online Pictures In a Cell Using a Formula »

April 12, 2024 - by Bill Jelen


The IMAGE function debuted in August 2022. It is only for online images that are available through a URL.

Excel 2024: Use People to Add Interest to Your Worksheet

Excel 2024: Use People to Add Interest to Your Worksheet »

April 10, 2024 - by Bill Jelen


Microsoft 365 subscribers now have access to 925 People in Excel. In a study conducted by YouTube, 90% of the most-watched videos have an emotive human face prominently on the title card.

Excel 2024: Add Meaning to Reports Using Data Visualizations

Excel 2024: Add Meaning to Reports Using Data Visualizations »

April 8, 2024 - by Bill Jelen


Three easy visualization tools were added to the Conditional Formatting dropdown in Excel 2007: Color Scales, Data Bars, and Icon Sets.

read more articles »

Featured Products


Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

December 2021

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!


MrExcel 2021 - Unmasking Excel

February 2021

This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.


Power BI for the Excel Data Analyst

July 2022

A step-by-step guide on how to use Power BI. Written with Excel fans in mind, but with every Power BI student at its heart.


Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.


see more products »