MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: Fast Worksheet Copy


January 27, 2020 - by Bill Jelen

Fast Worksheet Copy. Photo Credit: Joe Green at Unsplash.com

You can right-click any sheet tab and choose Move or Copy to make a copy of a worksheet. But that is the very slow way to copy a worksheet. The fast way: Hold down the Ctrl key and drag the worksheet tab to the right.

A close-up of the worksheet tab for January. The mouse cursor is a blank sheet with a plus sign and is immediately to the right of the January tab.

The downside of this trick is that the new sheet is called January (2) instead of February – but that is the case with the Move or Copy method as well. In either case, double-click the sheet name and type a new name.


After releasing the mouse button, a copy of the January sheet is added. The name of the new sheet is January (2).

Ctrl+drag February to the right to create a sheet for March. Rename February (2) to March.

Select January. Shift+select March to select all worksheets. Hold down Ctrl and drag January to the right to create three more worksheets. Rename the three new sheets.

Select January. Shift+select June. Ctrl+drag January to the right, and you’ve added the final six worksheets for the year. Rename those sheets.

Using this technique, you can quickly come up with 12 copies of the original worksheet.

A cartoon of the J spreadsheet Ctrl+Dragged to create the F spreadsheet. At the bottom, little cartoon M, A, M, J, J, A, S, O, N, D spreadsheets dance across the illustration.
Illustration: Walter Moore

Title Photo: Joe Green at Unsplash.com


This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.


Bill Jelen is the author / co-author of
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.