How to Insert Pictures from Graphics Files in Excel 2010
In Excel 2010, you can insert digital photos or scanned images that are saved as graphics files into your worksheets. Adding pictures to an Excel spreadsheet can create a calming effect, especially if the spreadhseet is delivering bad news.
On the Insert tab, click the Picture button in the Illustrations group.
The Insert Picture dialog box appears.
Locate and select the picture file you want to import.
Select an item in the File types list if you want to view only certain picture file types.
Click the Insert button.
The selected picture appears in the worksheet.
Move and resize the image as needed.
Click and drag inside the picture to move it into place, and click and drag the circular resizing handles to change the size of the picture. You can also rotate the image by clicking and dragging the green rotation handle above the image.
When you insert a picture from a graphics file into the worksheet, it's automatically selected (indicated by the selection handles around its perimeter and its rotation handle at the top). To deselect the graphic image, click anywhere in the worksheet outside of the image.
If you want to bring in a graphic image created in another graphics program that's not saved in its own file, select the graphic in that program and then copy it to the Clipboard (press Ctrl+C). When you get back to your worksheet, place the cursor where you want the picture to go and then paste the image in place (press Ctrl+V or click the Paste command button on the Home tab).