How do I duplicate a sheet in Excel
By
SpreadCheaters
Page last updated:
04/01/2023 |
Next review date:
04/01/2025
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
