Tuesday, February 15, 2011

How to Put Images in Cells on Excel 2007


1. Click the 'Insert' tab on the Office Ribbon.
2. Select a cell on your spreadsheet by clicking it with the cursor. The picture you insert will appear at this location.
3. Click the 'Picture' button on the 'Illustrations' panel of the Office Ribbon to insert a picture into your spreadsheet. Use the 'Open Picture' dialog to select a picture from your computer and click 'Open' to insert the picture onto your spreadsheet.
4. Resize the cells around your image. Click and drag the row and column headers so that your image is contained within the border of a single cell. If your image is large, click on the image and use the 'Resize' buttons along its border to scale it to a smaller size.
5. Right-click on your image and select 'Size and Properties.' Click the 'Properties' tab in the dialog window and choose 'Move and size with cells' from the 'Object Positioning' options. Click 'Close' to apply the changes.
6. Resize the cell containing the picture. The image will scale with the cell as you adjust the row height and column length.

Blogger news