Microsoft Excel 
ITTraining@sgul.ac.uk Page 7 St. George’s Information Services 
COPYING A WORKSHEET 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Just as you can copy the contents of cells and 
ranges within a worksheet, you can duplicate 
worksheets within a workbook. This technique is 
ideal for replicating layouts. For example, if you 
have a budget workbook that contains data for 
several departments, you can create a worksheet 
for the first department and then copy it to create 
identical worksheets for other departments. 
Try This Yourself: 
Same 
File Continue using the previous 
file with this exercise, or open 
the file E1324 Worksheet 
Techniques_1.xlsx... 
 
Right-click on Sheet1 to 
display the worksheet shortcut 
menu 
 
Select Move or Copy to 
display the Move or Copy 
dialog box 
 
Click on Create a copy so it 
appears ticked, then click on 
[OK] 
The new worksheet is named 
Sheet1 (2). Let’s create a 
“template” from this worksheet 
by deleting unwanted data... 
 
Select the range B7:E9, then 
press  to clear it 
 
Repeat step 4 to clear the 
ranges B14:E23, G7:J9 and 
G14:J23
, then press  + 
 to return to cell A1 
Now we can copy this 
“template” to create additional 
worksheets... 
 
Repeat steps 1 to 3 three 
times to create three copies of 
the template worksheet – this 
time without data 
The final worksheet should be 
named Sheet1 (5) 
 
1 
2 
For Your Reference… 
To copy a worksheet: 
1. Right-click on the worksheet to copy, then 
select Move or Copy 
2. Click on Create a copy so it appears ticked 
3. Click on [OK] 
Handy to Know… 
 You can copy the current worksheet using 
the HOME tab by clicking on Format in the 
Cells group, then clicking on Move or Copy 
Sheet. 
 The Before sheet options in the Move or 
Copy dialog box allow you to position the 
copied worksheet where you want. 
3 
6