XL97: Size of Scaled Picture Is Incorrect When Cropped

MORE INFORMATION

When you insert a picture into a worksheet or chart in Microsoft Excel 97, you can change the appearance of the picture by clicking the picture and clicking Picture on the Format menu.

You can change the scale of the selected picture by clicking the Size tab, and then changing the values in the Height or Width boxes. Using a value larger than 100 percent causes the picture to increase in size; using a value smaller than 100 percent causes the picture to decrease in size.

You can also crop, or trim, a picture by clicking the Picture tab, and then changing the values in the Left, Right, Top, or Bottom boxes.

When you crop a picture that is also scaled, Microsoft Excel crops the picture before scaling the picture. For example, if you create a picture that is 5 inches wide, scale the width of the picture to 200 percent, and then crop 1 inch from the left side of the picture, the result is a picture with a width of 8 inches. When you do this, Microsoft Excel uses the following calculation to determine the width of the picture: The result is not a picture with a width of 9 inches as in the following calculation: You can determine the size of a picture by clicking the Size tab in the Format Picture dialog box. The original size appears near the bottom of the dialog box.