MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy Excel Worksheet - Easy and Fast


August 27, 2014 - by Bill Jelen

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

Copy Excel Worksheet – Easy and Fast
Copy Excel Worksheet – Easy and Fast

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.

This is one of the tips in Learn Excel 2007-2010 from MrExcel – 512 Excel Mysteries Solved.


Bill Jelen is the author / co-author of
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.