Microsoft KB Archive/142147

Microsoft Knowledge Base

XL: How to Make and Size Circles and Squares on a Worksheet

Last reviewed: March 27, 1997
Article ID: Q142147

5.00 5.00c 7.00 | 5.00 5.00a

WINDOWS         | MACINTOSH

kbusage kbhowto

The information in this article applies to:

• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for Windows, version 5.0, 5.0c
• Microsoft Excel for the Macintosh, version 5.0, 5.0a

SUMMARY

In Microsoft Excel, it is possible to create a circle by using the Ellipse tool on the Drawing toolbar. It is also possible to create a square by using the Rectangle tool on the Drawing toolbar.

MORE INFORMATION

To create a circle, use the following steps:

1. If you do not have the Drawing toolbar displayed, click Toolbars on the View menu. In the list of toolbars, click Drawing, and then click OK.
2. On the Drawing toolbar, click the Ellipse button.
3. Press and hold down the SHIFT key. With the SHIFT key depressed, click the sheet (the place where you click will be where the upper-left portion of the circle will be positioned).
4. Drag the crossbar down and to the right to draw the circle.

The circle on your worksheet should now be selected.

To resize the circle, do the following:

1. If the circle is not selected, click the circle to select it.
2. Position the insertion point over one of the circle's handles such that the crossbar changes to a double-headed arrow.
3. Press and hold down the SHIFT key and drag the double-headed arrow until the circle is the desired size.

Squares can be created and resized using the same steps above; simply substitute the Rectangle tool for the Ellipse tool.

REFERENCES

For more information about Drawing Objects in Microsoft Excel version 7.0, click Answer Wizard on the Help menu, and type:

   How do I create a drawing object

For more information about Drawing Objects in Microsoft Excel version 5.0, click the Search button in Help and type:

   drawing

KBCategory: kbusage kbhowto KBSubcategory: Additional reference words: 5.00 5.00a 5.00c 7.00 Keywords : kbhowto kbusage Version : 5.00 5.00c 7.00 | 5.00 5.00a Platform : MACINTOSH WINDOWS 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: March 27, 1997 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.