XL98: Size of a Picture Is Larger in Excel

ID: Q178521


The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition


SYMPTOMS

In Microsoft Excel 98 Macintosh Edition, when you open a workbook that contains a picture object, the picture object may appear slightly larger than in earlier versions of Microsoft Excel.


CAUSE

This behavior occurs when you do the following:

  • You create a workbook in Microsoft Excel version 5.0 for the Macintosh.


  • -and-

  • You insert a picture in the workbook.


  • -and-

  • You save the workbook.


  • -and-

  • You open the workbook in Microsoft Excel 98 Macintosh Edition.



WORKAROUND

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

Method 1: Resize the Picture

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.


Note: To force the picture to align to the gridlines; click Draw on the Drawing toolbar, point to Snap, and then click To Grid.

Method 2: Remove the Border

To remove the border, follow these steps:
  1. Select the picture. On the Format menu, click Object.


  2. Click the Colors And Lines tab.


  3. In the Lines section, click the Color list, and click No Line.


  4. Click OK, and save the workbook.



MORE INFORMATION

This behavior is caused by a design change in Microsoft Excel 98. The increase in size is due to a border that is placed around the picture. In Microsoft Excel 5.0, when you format a picture with a border, Microsoft Excel places the border on top of the picture. In Microsoft Excel 98, when you format a picture with a border, Microsoft Excel 98 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.


REFERENCES

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

pictures
then double-click the selected text to go to the "Create pictures of cell, charts, and other objects" topic.

Additional query words: XL98 line

Keywords : xldraw
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb


Last Reviewed: January 12, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.