XL98: Dragging a Sheet Copies It Instead of Moves It

• Microsoft Excel 98 Macintosh Edition

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.

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.

REFERENCES

For more information about moving sheets, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

moving sheets

Additional query words: XL98

Keywords : kbdta xlui
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb