Quickly Copy Worksheets
September 16, 2021 - by Bill Jelen
![Quickly Copy Worksheets Quickly Copy Worksheets](/img/excel-tips/2021/09/quickly-copy-worksheets.jpg)
Problem: I’ve created the perfect report for January. I’ve formatted the column widths. I’ve changed the Page Setup. I have custom views. I need to make copies of the report for February through December in the current workbook.
Strategy: You need the Move or Copy command. Normally, you would right-click the January worksheet tab, choose Move or Copy, choose New Book, Create a Copy, OK. However, there is a faster way.
While holding down the Ctrl key, drag the January worksheet tab and drop it to the right of the January tab.
![A close-up of a sheet tab called January. Ctrl+Drag the sheet tab to the right. The mouse cursor is a white arrow dragging a sheet with a Plus sign on the sheet. This means you are copying the sheet.](/img/content/2021/09/LE10000055.jpg)
Watch the black triangle pointer. The worksheet copy will be added where the indicator appears.
Gotcha: The name for the new worksheet will be January (2). Double-click the worksheet name and type a new name.
If you make five copies of January, you can select January through June by selecting January and then Shift+Click on June. Ctrl+Drag January and drop after June to make copies for July through December. You will still have to manually rename all of the worksheets.
Additional Details: If you have two workbooks opened and use View, Arrange, Vertical, you can Ctrl+Drag a worksheet from one workbook to another.
This article is an excerpt from Power Excel With MrExcel
Title photo by Maximalfocus on Unsplash