You’ve created the perfect report for January. Now you need to make 11 copies for the other months.


Hold down the Ctrl key.

While holding down the Ctrl key, click on the sheet tab and drag to the right. You should see the mouse pointer change to an arrow pointing to a sheet with a + sign on it. Repeat this 10 more times to create 11 worksheets.

Downside: The sheets will be called Jan (2), Jan (3). You will have to rename each sheet.

Someday: Excel will be smart enough to use the Fill Handle logic to rename the sheets.  But not yet.