'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Cannot Insert Pictures Inside Cells in Excel 2021
Question details
The user needs a way to embed images directly into spreadsheet cells in Excel 2021, similar to the functionality available in newer Microsoft 365 versions.
- Product
- Microsoft Excel 2021
- Device & OS
- not provided
- Scenario
- The user is attempting to insert pictures securely inside spreadsheet cells after upgrading to Office Professional Plus 2021.
- Observed behavior
- The native 'Place in Cell' option is missing, and images can only be inserted as floating objects positioned over the cells or ranges.
Verify your exact Office version. The native 'Place in Cell' graphical interface feature is exclusive to Microsoft 365 subscriptions and is intentionally absent from perpetual licenses like Office 2021.
Size and Snap Floating Pictures to Cells
Since Excel 2021 does not support native in-cell local pictures via the user interface, you can manually snap floating images into cell bounds and lock their properties.
This method simulates the in-cell picture experience. By linking the floating object to the cell's boundaries, the image will move, filter, and resize alongside your spreadsheet data.
Go to the 'Insert' tab on the Excel ribbon, click 'Pictures', and choose 'This Device' to insert your image as a floating object over the grid.
Hold down the 'Alt' key on your keyboard while clicking and dragging the corners of the picture. This will automatically snap the image edges perfectly to the cell borders.
Right-click the formatted picture and select 'Size and Properties'. In the side pane under the 'Properties' section, choose the 'Move and size with cells' option.
Use the IMAGE Function for Online Pictures
Excel 2021 includes the newly introduced IMAGE function, which allows you to place pictures directly into cells as long as they are hosted online.
Easily Insert Local Pictures Inside Cells with WPS Office
If you don't want to use formulas or manually snap images to gridlines, WPS Spreadsheet provides a native, one-click 'Insert to Cell' feature for local pictures. It is entirely free and fully compatible with your existing Microsoft Excel (.xlsx) files.
- 1. Open your spreadsheet: Launch WPS Office and open your existing Excel (.xlsx) file.
- 2. Select the target cell: Click exactly on the cell where you want the picture to be securely placed.
- 3. Use the Insert to Cell feature: Navigate to the 'Insert' tab on the top ribbon, click 'Picture', and select 'Embed to Cell' from the dropdown menu.
- 4. Choose your image: Browse your local device for the image file and click 'Open'. The image will automatically lock natively inside the selected cell.
Frequently Asked Questions
Why is the 'Place in Cell' option missing in Excel 2021?
Microsoft limits certain new graphical features to Microsoft 365 subscribers to encourage subscriptions. Because Excel 2021 is a perpetual (one-time purchase) license, it only receives security updates, not new feature rollouts like the 'Place in Cell' UI button.
Can I convert an existing floating picture to an in-cell picture in Excel 2021?
No. Excel 2021 does not have the conversion functionality found in Microsoft 365 (which allows right-clicking a floating picture and selecting 'Put in Cell'). You must either manually snap it to the grid or use the IMAGE formula for web URLs.
Will my snapped floating pictures stay within the cell when I filter my data?
Yes, but only if you change their properties. You must right-click the image, open 'Size and Properties', and select 'Move and size with cells'. Without this setting, filtering rows will cause floating images to overlap and distort your view.
