Office Settings & Configuration

How to Fix Excel Place in Cell Option Disabled for Pictures

Emma Brown Oct 10, 2026 874 views

Question details

The user is unable to use the Place in Cell option for images in Excel because the feature is greyed out or completely disabled.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to embed a picture directly into an Excel cell for better formatting and data organization.
Observed behavior: The Place in Cell option is unavailable, which may be caused by workbook sharing restrictions, file-specific corruption, or an outdated Excel version.

Before you start

Ensure your Microsoft Office is updated to the latest version, as the Place in Cell feature is a newer addition to Microsoft 365 and is not supported in older legacy versions like Excel 2016 or 2019.

Solution 1Recommended

Test in a New Workbook and Migrate Data

Determine if the issue is isolated to a specific file by creating a new workbook and migrating your data.

File-specific glitches or legacy file formats (such as .xls) often restrict newer features. Creating a fresh workbook can bypass these hidden limitations.

Create a new workbook

Open Excel and press Ctrl+N to create a completely blank workbook.

Test the picture feature

Navigate to the Insert tab, select Pictures, and verify if the Place in Cell option is now active.

Copy original data

If the feature works, open your problematic workbook, highlight your data, and press Ctrl+C to copy it.

Paste into the new file

Go back to the new workbook, right-click cell A1, and use Paste Special to retain your values and formatting without copying over the file corruption.

Save in Modern Format: Always save the new workbook in the standard .xlsx format to ensure all modern features remain active.

Solution 2

Remove Workbook Restrictions and Sharing

Disable legacy shared workbook settings and unprotect sheets that may be blocking object insertion.

Solution 3

Repair Your Microsoft 365 Installation

If the feature fails across all workbooks, repairing the Office suite can fix missing or corrupted application files.

Insert Pictures into Cells Easily

Use WPS Spreadsheet to Seamlessly Insert Pictures into Cells

If Microsoft Excel continues to block your picture formatting, try WPS Spreadsheet. It features a robust, dedicated 'Insert Picture to Cell' function that perfectly embeds images into your grid without complex restrictions or file version errors.

1. Open your file in WPS Office: Launch WPS Spreadsheet and open your existing Excel workbook.
2. Select the target cell: Click on the specific cell where you want the picture to be embedded.
3. Access the Insert menu: Navigate to the Insert tab located on the top ribbon and click on the Picture button.
4. Choose Insert to Cell: From the dropdown menu, select the 'Insert Picture to Cell' option.
5. Select your image: Browse your computer for the desired image, select it, and click Open. The picture will automatically size itself perfectly within the cell.

Dedicated 'Insert Picture to Cell' feature that works effortlesslyFully compatible with Microsoft Excel (.xlsx and .xls) formatsFree to use, lightweight, and fast on all operating systemsFamiliar user interface requiring zero learning curve

Frequently Asked Questions

Why is the Place in Cell option missing entirely from my Excel ribbon?

The Place in Cell feature is a recent addition primarily available to Microsoft 365 subscribers. If you are using standalone versions like Office 2016, 2019, or even some builds of 2021, the feature is not supported and will not appear on your ribbon.

Does worksheet protection disable picture insertion?

Yes. If a worksheet is protected and the 'Edit objects' permission was not granted during the protection setup, you will not be able to insert, move, or place pictures in cells.

Can I convert an existing floating picture to be placed in a cell?

Yes, in supported Excel versions, you can simply right-click an existing floating image and select 'Place in Cell' from the context menu to embed it directly into the underlying cell.

Does saving the workbook as an older .xls file break the Place in Cell feature?

Yes, saving a workbook in the older Excel 97-2003 (.xls) format triggers Compatibility Mode, which disables many modern formatting features, including placing pictures directly inside cells.

Office App Problems