This has been a popular request we’re tracking as enhancement # 002418. We’ll be adding a “Duplicate” worksheet option to the worksheet context menu. Will update this thread once we have more to share.
Meanwhile, the best way to achieve this now is the following, though we realize it’s not ideal:
- Create a new empty worksheet
- Go to the worksheet you’d like to copy, select all using CTRL+A and the copy it to clipboard with CTRL+C
- Go to the new worksheet, select cell A1
- CTRL+V to paste
- Update the data type of all columns to match the column data types in the source worksheet.
Once we have the “Duplicate” worksheet option available, there will be no need for all of these steps.