Excel Tip of the Day

Move or copy a sheet from one workbook to another (Excel 97/2000/2001/2002)

If you work with several related workbooks, there may come a time when you decide you'd rather have all of the worksheets brought together into a single file. Fortunately, you don't have to go through a lot of tedious copying and pasting into new worksheets. Instead, you can simply move or copy the existing sheets directly into another workbook.

There are two basic ways to accomplish these tasks. You can drag the sheets to the appropriate file or use the Move Or Copy dialog box.

To move a sheet from one workbook to another using the mouse, start by opening both workbooks. Arrange the workbooks so that you can see both simultaneously. An easy way to do so is to select Window | Arrange from the menu bar, select the Horizontal option button, and click OK. When both workbooks are visible, simply drag the appropriate worksheet's sheet tab to move the sheet to the other workbook. To drag and create a copy of the sheet, leaving the original in place, press and hold the [Ctrl] key when you drag the tab (use the [command] key on the Mac).

To use the Move Or Copy dialog box, open both the source and destination workbooks. Then, select the sheet you want to move or copy and choose Edit | Move Or Copy Sheet from the menu bar. When the Move Or Copy dialog box appears, choose the appropriate workbook from the To Book dropdown list. Next, choose which existing sheet in the destination file should follow the new one from the Before Sheet list box. If you want to copy the worksheet instead of move it, select the Create A Copy check box. Finally, click OK.

(Content provided by Element K Journals)

(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
PrintPrint CloseClose

Copyright © 2001 - 2018 MJ Technologies, LLC.  All rights reserved.