Microsoft Excel
COPYING A WORKSHEET
Just as you can copy the contents of cells and have a budget workbook that contains data for
ranges within a worksheet, you can duplicate several departments, you can create a worksheet
worksheets within a workbook. This technique is for the first department and then copy it to create
ideal for replicating layouts. For example, if you identical worksheets for other departments.
1
Try This Yourself:
Continue using the previous
Same
file with this exercise, or open
File
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 2
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 +
3
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
6
time without data
The final worksheet should be
named Sheet1 (5)
For Your Reference… Handy to Know…
To copy a worksheet: You can copy the current worksheet using
1. Right-click on the worksheet to copy, then the HOME tab by clicking on Format in the
select Move or Copy Cells group, then clicking on Move or Copy
Sheet.
2. Click on Create a copy so it appears ticked
3. Click on [OK] The Before sheet options in the Move or
Copy dialog box allow you to position the
copied worksheet where you want.
[email protected] Page 7 St. George’s Information Services
