Moving a Worksheet Between Workbooks by Dragging and Dropping
You can also use the drag and drop feature to quickly copy or move worksheets between workbooks. First, open the workbooks you want to use for the copy or move. Choose Window, Arrange and select the Tiled option. Click OK to arrange the windows so that a small portion of each one appears on-screen. Select the tab of the worksheet(s) you want to copy or move. Move the mouse pointer over one of the selected tabs, click and hold the mouse button, and drag the tab where you want it moved. To copy the worksheet, hold down the key while dragging. When you release the mouse button, the worksheet is copied or moved.
Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
