Microsoft KB Archive/185417

= XL98: Dragging a Sheet Copies It Instead of Moves It =

Article ID: 185417

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q185417



SYMPTOMS
When you attempt to move a worksheet in Microsoft Excel 98 Macintosh Edition, the worksheet is copied instead of moved.



CAUSE
This behavior occurs when you drag a worksheet to another workbook.



WORKAROUND
To move a worksheet in Microsoft Excel 98, follow these steps:
 * 1) Ensure that the workbooks to which and from which you are copying are both open.
 * 2) Hold down the CONTROL key and click the tab of the worksheet you want to move.
 * 3) Click Move Or Copy on the shortcut menu that appears.
 * 4) When the Move Or Copy dialog box appears, click the workbook to which the sheet will be moved in the To Book list.
 * 5) In the Before Sheet list, click the sheet name you want the moved sheet to be placed before (to the left of). Click OK.

The sheet is then moved to the specified location.



STATUS
This behavior is by design in Microsoft Excel 98.



MORE INFORMATION
When you drag a worksheet in earlier versions of Microsoft Excel, the worksheet is moved instead of copied.

