XL97: Cannot Click Once to Create Arrows and Lines (163858)

MORE INFORMATION

In Microsoft Excel 97, after you click a button on the Drawing toolbar, you can use three different methods to create the drawing object in the worksheet or chart sheet.

Method 1: Clicking and Dropping

After clicking a button on the Drawing toolbar, if you click the worksheet or chart sheet once, a drawing object with a default size appears. If necessary, you can resize the object.

NOTE: This method is available for all drawing objects except lines, arrows, and connectors.

Method 2: Clicking Three Times

After clicking a button on the Drawing toolbar, click the worksheet or chart sheet once to establish the starting point. Then, click once more to create the ending point. If necessary, you can resize the object.

NOTE: This method is available only for connectors.

Method 3: Dragging

After clicking a button on the Drawing toolbar, drag the pointer to create the object. When the object is the size you want, release the mouse button. If necessary, you can resize the object.

NOTE: This method is available for all drawing objects, including arrows and lines.

When you attempt to create a line or an arrow by dropping it in Microsoft Excel 97, the arrow or line does not appear. This behavior occurs because arrows and lines require two endpoints. Clicking once creates only a single starting point; therefore, Excel cannot create the arrow or line. Other objects, such as rectangles, ovals, callouts, basic shapes, and flowchart elements, can be created by dropping them.

In earlier versions of Microsoft Excel, you can create objects in worksheets and chart sheets only by dragging. The other methods are supported only in Microsoft Excel 97 and later.