• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iOS
  • Mac
  • Android
  • Office

How to Insert Picture Into Excel Cell

By: Waseem Patwegar

Here is how to Insert Picture into Excel Cell, in case you come across the need to insert company logo or product pictures into Excel.

Insert Picture Into Excel Cell

Insert Picture Into Excel Cell

The Insert function in Microsoft Excel allows you to insert Shapes, Icons and Pictures from computer and also from the Internet into Excel.

This can be useful in a variety of work related situations. For example, if you are preparing a list of products, you can have an extra column containing pictures of the products.

After inserting pictures, you can embed them into Excel cells, which will make them move, resize, hide, unhide and filter along with the cells.

So, let is go ahead and take a look at the steps to Insert Picture Into Excel Cell and Lock the Picture to an Excel Cell.

1. Insert Picture into Cell in Excel

Follow the steps below to insert picture into a cell in Excel.

1. Open the Excel File into which you want to insert Picture

2. Click on the Insert tab > click on Illustrations and select Pictures option in Illustrations group.

Insert Pictures Option in Excel

3. On ‘Insert Picture’ screen, select the Picture (or Pictures) that you want to insert and click on the Insert button.

Insert Pictures From Computer Into Excel

The selected picture will be immediately available in your Excel File.

2. Resize Picture to Fit into Excel Cell

By default, pictures inserted into Excel remain in their own separate layer and you will find them moving or floating independent of the cells.

This allows you to resize the picture to match the size of the Cell or Cells into which it is being placed.

An easy way to fit picture within an Excel Cell is to first enlarge the Cell > press the ALT key > Move the picture into the Cell.

3. Lock Picture to Cell in Excel

When you insert Picture in Excel Cell, the image will not stick with the cell, when you move or resize Cells in the worksheet.

You can easily fix this issue by associating or locking the picture to the Cell into which it has been placed.

Once the picture is locked to the Cell it will move, resize, hide, unhide and filter along with that cell.

1. Right-click on the inserted picture and select Format Picture option in the contextual menu.

Format Inserted Picture in Excel

2. In Format Picture window, select Move and size with cells option in ‘Properties’ section.

Make Picture Move and Size With Cells in Excel

After this setting, the picture gets locked to the Cell into which it has been placed and it will move, resize, hide, unhide and even filter along with the Cell.

Note: In order to Filter Pictures in Excel, you will have to label or name the pictures.

Related
  • How to Insert PDF Into Excel
  • How to Insert Checkbox in Excel

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar



Gadget Guide

  • Should You Buy MacBook or Windows Laptop
  • How Much RAM Is Required in a Computer?
  • 12 Reasons to Switch to Chromebook
  • Check RAM Size & Type In Windows 10/11
  • Which Chromecast Model to Buy




About | Privacy Policy | Disclosure | Terms | Contact
© 2023 Techbout.com · All Rights Reserved