XL97: Size of a Picture is Larger in Microsoft Excel 97

• Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, when you open a workbook that contains a picture object, the picture object may be slightly larger in size than in earlier version of Microsoft Excel.

CAUSE

This behavior occurs when you do the following:

• You create a workbook in Microsoft Excel version 7.0.

      -and-
  

• You insert a picture in the workbook.

      -and-
  

• You save the workbook.

      -and-
  

• You open the workbook in Microsoft Excel 97.

NOTE: When you insert a picture, Microsoft Excel automatically places a border around it.

WORKAROUND

To work around this behavior, use one of the following methods.

Method 1: Remove the Border in Microsoft Excel 97

To remove the border, follow these steps:

1. Right-click the picture and click Format Picture.

2. Click the Colors And Lines tab.

3. Click the Color list and click No Line.

4. Click OK and save the workbook.

Method 2: Resize the Picture in Microsoft Excel 97

To resize the picture, follow these steps:

1. Click to select the picture.

2. Click and drag one of the fill handles to resize the picture.

REFERENCES

For more information about formatting pictures, click the Index tab in Microsoft Excel 97 Help, and type the following text:

   pictures, formatting