Microsoft Excel 
ITTraining@sgul.ac.uk Page 9 St. George’s Information Services 
MOVING OR COPYING A SHEET TO ANOTHER WORKBOOK 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
You can copy worksheets to other workbooks as 
required. For example, you might need to keep 
records for six different divisions – rather than 
send each division the entire set of records, you 
can copy their worksheet to another workbook and 
send them their data only. If worksheets exist in the 
other workbook, you will need to determine the 
order in which to place the copied worksheet. 
Try This Yourself: 
Same File Continue using the 
previous file with this 
exercise, or open the file 
E1324 Worksheet 
Techniques_6.xlsx... 
 
Click on the Maintenance 
worksheet tab 
We’ll copy this completed 
data to another workbook... 
 
Right-click on the 
worksheet tab to display 
the shortcut menu, then 
click on Move or Copy to 
display the Move or Copy 
dialog box 
 
Click on the drop arrow for 
To book, then select (new 
book) 
 
Click on Create a copy so 
it appears ticked 
This will create a new 
workbook as well as 
making a copy of the 
worksheet... 
 
Click on [OK] 
A new workbook will be 
created and Maintenance 
will be the only worksheet 
in the workbook… 
 
Save the new workbook as 
Maintenance.xlsx, then 
close it 
 
1 
2 
 4 
For Your Reference… 
To copy a sheet to another workbook: 
1. Right click on the worksheet tab, then click 
on Move or Copy 
2. Select either (new book) or the name of 
another workbook in To book 
3. Tick Create a copy, then click on [OK] 
Handy to Know… 
 To copy a worksheet into an existing 
workbook, make sure that you open the 
destination workbook first to ensure that it is 
listed in To book in the Move or Copy 
dialog box. 
5