X
wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time.
This article has been viewed 126,831 times.
Learn more...
As with other components of Microsoft Office, Microsoft Excel allows you to insert graphic images into your spreadsheets. You can insert any of the clip art images that come with Microsoft Office, or you can insert a picture file from your hard drive or from a Web page. Following are instructions on how to insert graphics into Microsoft Excel 2003, 2007, and 2010.
Steps
Method 1
Method 1 of 4:Inserting Clip Art
Method 1
-
1Choose the location where you want to insert the clip art. You can insert clip art in any worksheet cell or in the header or footer.
- To select a cell, click on it.
- To select a header or footer in Excel 2003, select "Page Setup" from the File menu and then click the Header/Footer tab on the Page Setup dialog.
- To select a header or footer in Excel 2007 or 2010, click the "Header & Footer" button in the Text group on the Insert menu ribbon.
-
2Access the "Insert" feature.
- In Excel 2003, select "Picture" from the Insert menu, then select "Clip Art."
- In Excel 2007 and 2010, select "Clip Art" from the Illustrations group on the Insert menu ribbon.
-
3Search for the clip art image you want. Type either a descriptive word or phrase in the "Search for" field of the Clip Art task pane or a portion of the file name. You can narrow your search with either or both of the following methods:
- Check only the boxes in front of the items in the "Search in:" dropdown list that represent the places you want to search for a clip art image.
- Check only the "Clip Art" box in the "Results should be:" dropdown list. (The other available options are Photographs, Movies, and Sounds.)
-
4Click the "Go" button.
-
5Select the clip art item in the results list that you choose to insert it into your spreadsheet.
Method 2
Method 2 of 4:Inserting a Picture From a File
Method 2
-
1Choose the location where you want to insert the picture.
-
2Access the Insert feature.
- In Excel 2003, select "Picture" from the Insert menu, then select "From File."
- In Excel 2007 and 2010, select "Picture" from the Illustrations group on the Insert menu ribbon.
-
3Browse to the picture you want to insert in the Insert Picture dialog. Double click a folder to open it, or type the picture name in the "File name:" field. You can also use the drop-down field to the right of the "File name:" field to narrow the available pictures to a particular file type.
-
4Insert the picture. Either click the "Insert" button or double-click the picture file.
- When you insert a picture this way, it increases the overall size of your Excel file. You can instead insert a link to the picture by clicking the down arrow to the right of the "Insert" button and clicking "Link to File." If you later move the picture to a different location on your computer, however, the link will be broken and you will have to re-create the link to have the picture available again.
Method 3
Method 3 of 4:Inserting a Picture From a Web Page
Method 3
-
1Go to the Web page that displays the image you want to insert.
-
2Right-click the image. A popup menu appears.
-
3Select "Save Picture As" from the popup menu.
-
4Give the picture file a name. Enter it in the "File name:" field.
-
5Click the "Save" button.
-
6Follow the instructions under "Inserting a Picture From a File." Browse to the picture file you created or enter its name in the "File name:" field of the Insert Picture dialog.
Method 4
Method 4 of 4:Copying a Picture From a Web Page
Method 4
-
1Go to the Web page that displays the image you want to copy.
-
2Right-click the image. A popup menu appears.
-
3Select "Copy" from the popup menu.
-
4Right-click the place in your spreadsheet where you want to insert the picture. Another pop-up menu appears.
-
5Select "Paste" from the popup menu. Your picture appears at the location you selected.
- If you chose a picture that is hyperlinked to another Web page, you will see a hyperlink to that Web page in place of the image you wanted. If this happens, return to the Web page that featured the image you want and follow the instructions under "Inserting a Picture From a Web Page."
Community Q&A
-
QuestionI would like to insert a PDF image, not a JPEG. How can I do this?
Community AnswerPDFs aren't images, and thus can't be inserted in the same way. You can use a free internet service to convert your PDF into an image (just search PDF to PNG) and then insert it.
Warnings
- Spreadsheet headers and footers are visible with the rest of the spreadsheet in Excel 2003 and earlier versions only by using the Print Preview feature.Thanks!
- Be aware of the usage rights for any graphic image you plan to incorporate into your Excel spreadsheet before you use them, if you plan to distribute your spreadsheet outside your office. The images in the Microsoft Office Clip Art and Media Library can be used for any purpose other than reselling the images themselves; the same is true for most stock photography when you buy it. If you have any doubts about your rights to an image, contact the image owner for permission.Thanks!


























































