How do I duplicate a sheet in Excel

You can watch a video tutorial here.

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. Having created and formatted a sheet, you may want to duplicate it to retain the format or to use it as a template

Step 1 – Open the Move or Copy box

– Select the sheet
– Right-click to open the context menu
– Select Move or Copy

Step 2 – Set the parameters

– Tick the Create a copy checkbox
– Click OK

Step 3 – Check the result

– The sheet is duplicated with the same name as the original sheet with a (2) added