How to Insert Picture in Protected Excel Sheet? Try Hacks!

Mark Regan
Published: May 23rd, 2026 • 5 Min Read

Microsoft Excel is used in daily work to store data in manageable way. Users use Excel sheets to easily manage reports, invoices, dashboards, forms, etc. However, many users face problems when they try to insert picture into Excel sheets. In most scenarios, users can use “CTRL + V” to add image in Excel, but this method alters all formatting in XLS worksheet & didn’t work in protected Excel. MS Excel blocks users from inserting images because the worksheet is locked or shared by another user. Sometimes users also notice Excel picture greyed out issue that stops users from adding logos, signatures, screenshots, profile photos, etc. In this guide, users get smart & easy hacks that help you to insert picture in protected Excel sheet. This article also explains how to fix permissions in protected Excel & provides direct ways to insert images without damaging worksheet protection.

insert picture in protected excel sheet

Unable to Insert Pictures in Locked | Protected Excel Sheet! Why?

In Microsoft Excel, images are treated like objects. If your worksheet has protection enabled, Excel will stop you from inserting, moving, resizing, & editing objects. There are some other common reasons mentioned below.

Without ‘Edit Objects’ permission, you cannot add picture to protected Excel spreadsheet.
Sometimes, workbook itself is protected, not just sheet.
An Excel file is opened in protected view or read only mode.
Many times, older shared workbook mode limits some features.
Corporate security settings also disable object insertion.

In some cases, “insert” option becomes unavailable because of well-known Excel insert pictures greyed out problem. Nevertheless, users can solve this issue by removing Excel protection.

How to Insert Picture in Password-Protected XLS Sheet without Password?

Many users search quick method to “insert picture in protected Excel sheet without password” access, but they don’t know that Excel security cannot always be bypassed. Users can utilize some of mentioned legal & safe methods to insert images into protected XLS worksheet.

Method 1: Check Object Insert Permission

Sometimes, XLS worksheet protection allows object editing, even Excel cell is locked. Users need to first check “Object insert permission is “enabled or disabled.” Users need to follow these steps to insert image in Excel cell.

Firstly, open protected worksheet.
Now go to “Insert” option.
Choose Picture option.
You can choose between two options: “Place in cell” & “Place over cell.”
After that, you select “Insert picture from.”
Pick any choice that fits your needs.
Once done, picture in insert in Excel.

Note: If users want to picture in cell, then they need to choose “Place in cell” option, that insert the image within cell. This option didn’t alter any other data in Excel sheet. If users don’t have any data issues, they can insert image in place of cell. It cover multiple excel cells and add your image in the Excel. Users need to choose option according to their requirement.

Fix Excel Insert Picture Greyed Out Error

The issue of ‘Insert Pictures’ option being greyed out in Microsoft Excel 365. Its older versions are extremely common. Here are some strategies to address & fix this error.

Disable Protected View

Firstly, users need to go to File > Options.
Now you need to navigate to Trust Center.
Click “Trust Center Settings“.
After that, “Open Protected View“.
Once done, you need to disable unnecessary restrictions.

Exit Excel Compatibility Mode

Sometimes, older version didn’t support image insertion in Excel. Users just need to—

Click File > Save As.
Save your workbook in .xlsx format.
After that, reopen XLSX file.

Check Shared Workbook Settings

The issue of inserting images into shared workbooks in Excel is typically shown because of older shared workbooks. Microsoft recommends users to use ‘co-authoring’ instead of legacy shared workbook feature. To fix this issue you need to follow this steps.

Save workbook to OneDrive or SharePoint.
Disable legacy sharing.
Now you need to enable collaborating editing.

Forgot Excel Password & Can’t Insert Pictures? Try Fix!

If you are unable to insert picture in protected Excel sheet because you forgot to enable permissions & also don’t remember password, then here is quick fix. Excel security restrictions are created to prevent changes in XLS file structure. It restricts users from placing pictures, shapes, & objects. Download BitRecover Office Password Remover Tool to help users protect Excel sheets from being unprotected. There are users can download this application in any Windows OS editions. No need to worry about data. Download free version of this tool to remove known passwords from XLS | XLSX files.

Download Now Purchase Now

Steps to Save Protected Excel to Unprotected

Download Excel Password Removal Tool.
Add files to the software.
Then, click on “Click to Show Password.”
Now tap on “Remove” to save protected sheet as unprotected.

Pay Attention Please: Once you get unprotected Excel files, you just need to follow above steps and then insert picture in Excel sheet. This tool basically helps you to insert picture if you forgot the password of XLS worksheet.

Author Last Words,

Trying to insert picture in protected Excel sheet file can be frustrating when you don’t have permissions. If you are restricted & workbook sharing blocks also stop users from adding images in XLS files. Nevertheless, users get some easy method that help you add images in Excel within minutes. If users have already enabled the “Object Insert Permission,” then they can successfully insert image without requiring software. If users forgot the password and don’t enable this permission, they can move to suggested alternative solution that helps you unprotect file first, after that, you can insert image. I hope you get every solution that helps you to add images in Excel sheet.