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


Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.


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.


Financial Modelling in Power BI

September 2022

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


Programming PowerPoint with VBA

February 2022

This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.


see more products »