"

Inserting an Illustration in a Worksheet

Inserting an Illustration in a Worksheet

Insert an image, an icon, or a picture to create interest on the worksheet or to help convey a concept or link users to another worksheet.

To insert an image, an icon, or a picture on a worksheet, either open an existing Excel spreadsheet or create a new one. 

  1. In an open Excel worksheet start by:
      • Selecting the cell. Click on the cell where you want to insert the image.
      • Inserting the image. Go to the “Insert” tab on the ribbon at the top of the Excel window.
Inserting the image
Insert tab

2. Choosing the Pictures button: In the “Illustrations” group, click on the “Pictures” button.

Choosing the Pictures button

This will open a dropdown window with two options.

Place in Cell
Insert a picture directly in the cell.

Place in Cell.

Place over Cells
Insert a picture on top of the grid, floating outside the boundaries of cells.

Place over Cells.
Place over Cells.

3. Choose an option (Place in Cell or Place over Cell) to see the Insert Picture From list.

Option to see the Insert Picture From list
Insert Picture From

 

An image can be inserted from your computer (This Device), for the Microsoft Gallery (Stock Images) or from online (Search on web…).

4. Select an option from the Insert Picture From list.

Insert Picture From list
Insert Picture From List

 

5. Select the image file you want to insert, and then click the Insert button.

Stock Image Gallery
Stock Image Gallery

 

The image will then be placed in the worksheet.

Image placed on worksheet.
Image Placed on Worksheet

License

Icon for the Creative Commons Attribution 4.0 International License

Introduction to Excel for Business Data Copyright © by Julie Romey; Sherie Guess; and Gwyn J. Booth is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

Share This Book