copying worksheets

  • Thread starter Thread starter Carolyn
  • Start date Start date
C

Carolyn

Is it possible to make multiple copies of a worksheet and
add them to the same workbook?
 
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.
 
Back
Top