How to duplicate a tab in Excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-–-How-to-duplicate-a-tab-in-Excel.png)
An Excel file is called a workbook and it contains multiple worksheets. The number of worksheets in a workbook is limited only by the memory of your computer. Worksheets are also known as tabs because of how they are displayed in the workbook. Having created and formatted a sheet, you may want to duplicate it to retain the format.
Step 1 – Open the Move or Copy box
![](https://spreadcheaters.com/wp-content/uploads/Step-1-–-How-to-duplicate-a-tab-in-Excel.png)
– Select the tab
– Right-click to open the context menu
– Select Move or Copy
Step 2 – Set the parameters
![](https://spreadcheaters.com/wp-content/uploads/Step-2-–-How-to-duplicate-a-tab-in-Excel.png)
– Tick the Create a copy checkbox
– Click OK
Step 3 – Check the result
![](https://spreadcheaters.com/wp-content/uploads/Step-3-–-How-to-duplicate-a-tab-in-Excel.png)
– The sheet is duplicated with the same name as the original sheet with a (2) added