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


Supercharge Power BI - 3rd Edition

February 2021

Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.


Financial Modelling in Power BI

September 2022

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


Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition

May 2022

Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts.


Cool Excel Sh*t

March 2021

Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.


see more products »