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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

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...
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,843
Messages
5,507,634
Members
408,641
Latest member
billigee

This Week's Hot Topics

Top