copying worksheets

C

Carolyn

Is it possible to make multiple copies of a worksheet and
add them to the same workbook?
 
P

Paul

Carolyn said:
Is it possible to make multiple copies of a worksheet and
add them to the same workbook?

You can copy a worksheet to the same workbook. Right-click the worksheet tab
and use "Move or Copy", remembering then to check the "Create a copy" box.
Doing this several times will, of course, create several copies.

You can also create a copy of multiple worksheets at one time by grouping
the sheets before doing the above. To group worksheets, click the tab of the
first and then hold down Shift whilst clicking the tab of the last. Don't
forget to ungroup afterwards (right-click a tab and use "Ungroup sheets").

You can combine these to create multiple copies: copy one and you have two;
group and copy these and you have four; etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top