Excel 2020: Fast Worksheet Copy
January 27, 2020 - by Bill Jelen
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.
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.
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.
Title Photo: Joe Green at Unsplash.com
This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.