How do I copy a single excel worksheet onto an additional 50 worksheets?

Question

I have a project that I am working on and I don't want to hit copy and paste a few hundred times. I want to copy a worksheet that I set up onto an additional 50 worksheets in the workbook. I don't need anything filtered, and the additional sheets are already created (blank of course) and named. How the heck do I do this?

Answer 1

actually you can do this pretty easily by "grouping" your worksheets.

first, go to the sheet you want to copy.  press <CTRL>A to select the contents of the entire sheet.

now (for the fun part)...

click the tab of the first blank sheet.

hold down your shift key and then click the tab of the last sheet in your list.  You'll notice the tabs turn white (depending on if you've colored your tabs or not).  You'll also notice in the excel title bar (blue bar on top) it shows [GROUP].  This means that whatever you do to one sheet in your group, will be done to ALL sheets in that group.  

so now just "paste" into one sheet, and it gets pasted into every sheet you've grouped.

this is also a great method to widen all the same columns/rows, change formats, etc, etc. of a group of sheets all at one time.

have fun...

--------more---------

btw, to un-group them just right click on one of the tabs and select "Ungroup sheets" from the menu.  If you leave them grouped, whatever you typed in one sheet, gets typed in all sheets.

Answer 2

You have two options:

click on the page you want to replicate, hit Ctrl A to highlight the entire page. Click on the blank page and hit Ctrl V to paste. You might have to double click at the top of the columns to get them to the right size though. Repeat Ctrl V, etc on each blank labeled page.

Or your other option is to:

Erase all your labeled pages, sorry. This one will copy everything without need for modifying the columns, but opens up a new tab with the info needed.

Right click on the bottom tab of the page you want to copy, and chose move or copy. Chose where you want the new tab, and check the copy box at bottom.