Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/172485

From BetaArchive Wiki

Article ID: 172485

Article Last Modified on 10/19/2000


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q172485


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.


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.

This behavior is caused by a design change in Microsoft Excel 97. The increase in size is due to a border that is placed around the picture. In Microsoft Excel 7.0, when you format a picture with a border, Microsoft Excel places the border on top of the picture. In Microsoft Excel 97, when you format a picture with a border, Microsoft Excel 97 places the border outside the picture. This causes the picture to be slightly larger in size.

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

This problem no longer occurs in Microsoft Excel 2000.


To work around this behavior, use either 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.


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

pictures, formatting

then double-click the selected text to go to the "Insert and edit a picture or clip art" topic.

Additional query words: XL97 line

Keywords: KB172485