XL2000: Cannot Drag Drawing Objects Between Worksheets (212018)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q212018

SYMPTOMS

You cannot use the ALT key to drag a drawing object or an AutoShape from one worksheet to another in the same workbook.

NOTE: In contrast, you can drag a selection of cells from one worksheet to another.

WORKAROUND

To move a drawing object or an AutoShape from one worksheet to another in the same workbook, use either of the following methods.

Method 1: Use a Cut and Paste Operation

  1. Select the drawing object or AutoShape.
  2. On the Edit menu, click Cut.
  3. Click the tab for the worksheet on which you want to place the object.
  4. On the Edit menu, click Paste.

Method 2: Arrange the Worksheet in Two Windows

  1. On the Window menu, click New Window.

    A new window with a copy of the workbook appears. For example, if the active workbook in step 1 is called Book1.xls, Excel creates two windows called Book1.xls:1 and Book1.xls:2.
  2. On the Window menu, click Arrange.
  3. In the Arrange Windows dialog box, click Tiled, and then click OK.
  4. In the second window, click the tab of the worksheet on which you want to place the drawing object.
  5. Activate the first window.
  6. In the first window, hold down the ALT key and drag the drawing object to the second window. Release the ALT key.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

You can drag a range of cells from one worksheet to another in the same workbook by pressing the ALT key while you drag the cells. For example, if you want to drag cells A1:A3 from Sheet1 to Sheet2, follow these steps:
  1. Select cells A1:A3 on Sheet1.
  2. Hold down the ALT key, and drag the range of cells on top of the tab for Sheet2.

    When the sheet tab changes color, the sheet is active. Release the ALT key.
  3. Drag the cells to the location you want on Sheet2.
  4. Release the mouse button to paste the cells.
This functionality does not apply when trying to drag drawing objects between worksheets.

REFERENCES

For more information about moving selected cells, click Microsoft Excel Help on the Help menu, type Copy cell data in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbbug kbpending KB212018
©2003 Microsoft Corporation. All rights reserved.