XL98: Size of a Picture is Larger in Excel

Last reviewed: February 2, 1998
Article 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 be slightly larger in size 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
Solution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.