- In Excel, right-click on the tab of the worksheet you would like to copy.
- Select Move or Copy.
- In the Before Sheet section, select the worksheet that comes after the one you are copying. This will ensure that the copied version is organized next to the worksheet being copied.
- Ensure Create a Copy is marked.
- Click OK.