Copy one sheet mutiple times

D

DDM

Spell, one way:

1-Click and HOLD the left mouse button on a worksheet tab; drag the mouse to
the left or right (watch for the little black arrow); press and HOLD Ctrl;
release the left mouse button; release Ctrl. That gets you one copy. You
have a total of two.
2-The copied worksheet from (1) above should be selected. Press and HOLD
Ctrl and click the original worksheet tab. That should select both of them.
Now repeat step 1. That gets you two more copies; total of four.
3-Repeat (1) and (2) as necessary. When you're done, right-click a worksheet
tab and (if necessary) select Ungroup Sheets.
 

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