Topic: office

Moving Excel Worksheets

19 Jan 04

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.

See Other tips, Legacy Tips