Insert a picture or clip art

You can insert or copy pictures and clip art (clip art: A single piece of ready-made art, often appearing as a bitmap or a combination of drawn shapes.) into an Excel worksheet or a PowerPoint presentation from many different sources, including downloading from a clip art Web site provider, copying from a Web page, or inserting from a folder where you save pictures. You can also use pictures and clip art as backgrounds for your slides in PowerPoint.

This article discusses inserting pictures or clip art in Excel or PowerPoint. For information about how to insert pictures or clip art in Word, see Insert a picture or clip art. For information about how to insert a screenshot, see Insert a screenshot.

What do you want to do?


Insert clip art

Which Office program are you using?


Excel

  1. Open the spreadsheet that you want to add clip art to.
  2. On the Insert tab, in the Illustrations group, click Clip Art.

Excel  Ribbon Image

  1. In the Clip Art task pane (task pane: A window within an Office program that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.), in the Search for text box, type a word or phrase that describes the clip art that you want, or type all or some of the file name of the clip art.

To narrow your search, in the Results should be list, select the check boxes next to Illustrations, Photographs, Videos, and Audio to search those media types.

  1. Click Go.
  2. In the list of results, click the clip art to insert it.

PowerPoint

  1. Click the slide that you want to add the clip art to.
  2. On the Insert tab, in the Images group, click Clip Art.

PowerPoint Ribbon Image

  1. In the Clip Art task pane (task pane: A window within an Office program that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.), in the Search for text box, type a word or phrase that describes the clip art that you want, or type all or some of the file name of the clip art.

To narrow your search, in the Results should be list, select the check boxes next to Illustrations, Photographs, Videos, and Audio to search those media types.

  1. Click Go.
  2. In the list of results, click the clip art to insert it.

 Tip   To insert clip art into the notes pages of your presentation, switch to Notes Page view, and then do the steps above.

Top of Page Top of Page

Insert a picture from a file

 Note   To insert a picture from your scanner or camera, use the scanner or camera software to transfer the picture to your computer. Save the picture, and then insert it by following the instructions below. For more information about how to transfer a picture file from your camera or scanner to your computer, see the documentation included with the camera or scanner.

Which Office program are you using?


Excel

  1. Click where you want to insert the picture.
  2. On the Insert tab, in the Illustrations group, click Picture.

Excel  Ribbon Image

  1. Locate the picture that you want to insert, and then double-click it. For example, you might have a picture file located in My Documents.

To add multiple pictures, press and hold CTRL while you click the pictures that you want to insert, and then click Insert.

  1. To resize a picture, select the picture you have inserted in the spreadsheet. To increase or decrease the size in one or more directions, drag a sizing handle away from or toward the center, while you do one of the following:
    • To keep the center of an object in the same location, press and hold CTRL while you drag the sizing handle.
    • To maintain the object's proportions, press and hold SHIFT while you drag the sizing handle.
    • To both maintain the object's proportions and keep its center in the same location, press and hold both CTRL and SHIFT while you drag the sizing handle.

 Notes 

  • Adding pictures can significantly increase the file size of your workbook. You can control this file size by making choices about the resolution (resolution: The fineness of detail in an image or text produced by a monitor or printer.) of a picture and the quality or compression of a picture. For more information, see Reduce the file size of a picture.
  • If you insert a picture using the Link to File or Insert and Link options, make changes such as adding artistic effects, select the Discard editing data under Image Size and Quality options (under Options, Advanced tab) and then save the file, when you reopen the file, you will see the original picture. This occurs because the picture editing data has been deleted. To keep both the link and the edits, do not select the Discard editing data check box.

Link to File adds a link to the picture and that is the only source for the picture. If you open the workbook without access to the file location you will see a red X instead of your picture. Insert and Link links to the picture, but also adds a copy to the file. If you open the workbook without access to the file location you see the embedded picture.

PowerPoint

  1. Click where you want to insert the picture.
  2. On the Insert tab, in the Images group, click Picture.

PowerPoint Ribbon Image

  1. Locate the picture that you want to insert, and then double-click it. For example, you might have a picture file located in My Documents.

To add multiple pictures, press and hold CTRL while you click the pictures that you want to insert, and then click Insert.

  1. To resize a picture, select the picture you have inserted in the slide. To increase or decrease the size in one or more directions, drag a sizing handle away from or toward the center, while you do one of the following:
    • To keep the center of an object in the same location, press and hold CTRL while you drag the sizing handle.
    • To maintain the object's proportions, press and hold SHIFT while you drag the sizing handle.
    • To both maintain the object's proportions and keep its center in the same location, press and hold both CTRL and SHIFT while you drag the sizing handle.

 Notes 

  • Adding pictures can significantly increase the file size of your presentation. You can control this file size by making choices about the resolution (resolution: The fineness of detail in an image or text produced by a monitor or printer.) of a picture and the quality or compression of a picture. For more information, see Reduce the file size of a picture.
  • If you insert a picture using the Link to File or Insert and Link options, make changes such as adding artistic effects, select the Discard editing data under Image Size and Quality options (under Options, Advanced tab) and then save the file, when you reopen the file, you will see the original picture. This occurs because the picture editing data has been deleted. To keep both the link and the edits, do not select the Discard editing data check box.

Link to File adds a link to the picture and that is the only source for the picture. If you open the presentation without access to the file location you will see a red X instead of your picture. Insert and Link links to the picture, but also adds a copy to the file. If you open the presentation without access to the file location you see the embedded picture.

Top of Page Top of Page

Insert a picture from a Web page

Which Office program are you using?


Excel

  1. On the Web page, right-click the picture that you want, and then click Save Picture As on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.).
  2. Enter the name that you want in the File name box, and then click Save.
  3. In your spreadsheet, on the Insert tab, in the Illustrations group, click Picture.

Excel  Ribbon Image

  1. Locate the picture that you saved in step 2, and then click Insert.

 Tip   You can also copy and paste the picture from the Web page. On the Web page, right-click the picture that you want, and then click Copy on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.). In your spreadsheet, right-click where you want to insert the picture, and then click Paste. Make sure that the picture that you choose is not hyperlinked (hyperlink: A word, phrase, picture, icon, symbol or other element in a computer document or webpage on which a user may click to move to another part of the document or webpage or to open another document, webpage, or file.) to another Web page. If you choose a picture that is hyperlinked to another Web page, it will be inserted in your document as a hyperlink to that Web page instead of as an image.

PowerPoint

  1. On the Web page, right-click the picture that you want, and then click Save Picture As on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.).
  2. Enter the name that you want in the File name box, and then click Save.
  3. On your slide, on the Insert tab, in the Images group, click Picture.

PowerPoint Ribbon Image

  1. Locate the picture that you saved in step 2, and then click Insert.

 Tip   You can also copy and paste the picture from the Web page. On the Web page, right-click the picture that you want, and then click Copy on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.). In your presentation, right-click where you want to insert the picture, and then click Paste. Make sure that the picture that you choose is not hyperlinked (hyperlink: A word, phrase, picture, icon, symbol or other element in a computer document or webpage on which a user may click to move to another part of the document or webpage or to open another document, webpage, or file.) to another Web page. If you choose a picture that is hyperlinked to another Web page, it will be inserted in your document as a hyperlink to that Web page instead of as an image.

Top of Page Top of Page

Apply a picture style

Applies to both Excel and PowerPoint

You can apply a picture style to make your picture or clip stand out in your spreadsheet or presentation. Picture styles are combinations of different formatting options, such as picture border and picture effects, and are displayed in thumbnails in the Picture Styles gallery. When you place your pointer over a thumbnail, you can see how the Picture Style looks before you apply it.

  1. Click the picture or clip that you want to apply a picture style to.
  2. Under Picture Tools, on the Format tab in the Picture Styles group, click the Picture Style that you want.

PowerPoint Ribbon Image

Example of Picture Styles group in PowerPoint

If you do not see the Format or Picture Tools tabs, make sure that you have selected a picture. You may have to double-click the picture to select it and open the Format tab.

To see more Picture Styles, click the More button Button image.

Top of Page Top of Page

Use a picture or clip as a slide background

Applies only to PowerPoint

  1. Click the slide that you want to add a background picture to.

To select multiple slides, click the first slide, and then press and hold CTRL while you click the other slides.

  1. On the Design tab, in the Background group, click the Dialog Box Launcher Button image.

PowerPoint Ribbon Image

  1. Click Fill, and then click Picture or texture fill.
  2. Under Insert From, do one of the following:
    • To insert a picture from a file, click File, locate the picture that you want to insert, and then double-click it.
    • To paste a picture that you copied, click Clipboard.
    • To use clip art as a background picture, click Clip Art, and then in the Search text box, type a word or phrase that describes the clip (clip: A single media file, including art, sound, animation, or movies.) that you want, or type all or part of the file name of the clip, click Go, and then click the clip to insert it.
  • To include clip art that is available on Office.com in your search, select the Include content from Office.com check box.

 Tip   Once you have inserted the picture, you can crop it, add an artistic effect to it, change the brightness or contrast, recolor it, or remove the picture background.

Top of Page Top of Page

 
 
Applies to:
Excel 2010, PowerPoint 2010