Saturday, May 28, 2011

How to Work With Pictures in Excel 2007


Inserting the Picture File
1. Open the Excel worksheet.
2. Click the 'Insert' tab on the command ribbon.
3. Click the 'Picture' button on the 'Illustrations' group.
4. Click the saved image file from the 'Picture Library' or other location, such as the Desktop. The picture file appears over the worksheet. The 'Picture Tools' ribbon appears with tabs, such as 'Format.'
Editing the Picture
5. Click the 'Format' tab in the 'Picture Tools' ribbon. The ribbon displays four groups of commands: Adjust, Picture Styles, Arrange and Size.
6. Select a command and click the down-arrow, such as Brightness or Contrast from the 'Adjust' group. For example, to adjust the brightness, you can point over the list of increments ranging from ' 40%' for an extremely bright look to '-40%' for an extremely dark look.
7. Click the down-arrow on 'Picture Styles' to view the variety of frames and effects for your picture. Point over the command button to display a preview of the effect. For example, your picture can convert to a framed picture when you point over the 'Simple Frame, White' button.
8. Click a command button from the 'Size' group. For example, adjust the picture size by inserting values in the height or width text boxes. Click the 'Crop' command to display dark crop marks on the outer edge of the picture. Click and drag these crop marks to adjust the borders and delete unwanted items from the picture.
9. Click and drag the picture to move it anywhere on the worksheet.
10. Save this Excel file.

Blogger news