Maybe you want to create a back-up worksheet, or you want to create a new worksheet but don’t want to redo the formatting. The long (and inefficient) way is:
Right-click on the worksheet tab for which you want to create a copy. Select the Move or Copy option. Check the “Create a Copy” check box. Click OK.
This will create a copy of the worksheet. While this is a perfectly fine way to copy a worksheet in Excel, it’s not the most efficient way of doing this. In this tutorial, I will show you a super quick and efficient way to copy a worksheet in Excel.
How to Copy a Worksheet in Excel
Here are the steps: This would create a copy of the worksheet:
Note: If you want to have the copy of the worksheet appear to the left of the original worksheet, drag the mouse to the left side.
A quick way to move rows and columns in Excel. Increase Excel Tab Numbering as You Create a Copy. How to Quickly Insert New Cells in Excel.
