King Web Design and Computer Services Pty Ltd

Create a copy of an existing Excel worksheet

Here is the way to copy a worksheet, either within the current book or into a different one. Useful if you need to start a new sheet that includes some or all of the data and formatting of an existing sheet:
1. Right-click on the sheet tab of the sheet you want to copy.
2. Choose Move Or Copy.
3. Select the Create A Copy check box in the bottom-left corner of the
Move Or Copy dialog box.
4. Choose a different workbook, if desired, from the To Book drop-down list.
(Make sure the other workbook is open to show up in the list.)
You can also select New Workbook.
5. In the Before Sheet list box, specify where you want the copied sheet to go
within the specified workbook.
6. Click OK.

posted by King Web Design And Computer Services Pty Ltd @ 12/11/2009 09:24:00 AM