How to copy several worksheets

hunycombs

New Member
Joined
Apr 22, 2010
Messages
7
How do I copy several worksheets at one time... I am currently right clicking copying and I need to have 30 plus of the same worksheet... IS THERE AN EASIER WAY !!!! thanks
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

prabby25101981

Active Member
Joined
Jul 28, 2010
Messages
348
If the worksheets are in one workbook, you can press CTRL, and click all worksheets that you want to copy. This will select them all. Now, you can copy them all at once...
 

Watch MrExcel Video

Forum statistics

Threads
1,108,728
Messages
5,524,486
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top