Here's our Microsoft Office Tip for.. August 16, 2005
Click Here to see a complete list of all of our previously released Tips!
Moving Excel Worksheets
Do you know you can copy an entire sheet from one workbook to another?
To do so, open the source workbook and choose Edit, Move Or Copy Sheet. When the Move Or Copy dialog box opens, open the Book drop-down list and choose New Book. Now select the Create A Copy check box and click OK. Excel copies the selected sheet to a new workbook.
This option is helpful when you want to share with someone a sheet but not the entire workbook. Or you can use this feature when you want to base a new workbook on existing data.