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
Excel Subtotals Straight to the Point

I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.