MS Office Excel: duplicate table
If you want to duplicate an Excel spreadsheet, you can of course copy and paste the contents. With a little trick it is even easier:
Copy the Excel table and settings
If you copy the contents of one table in Excel and paste it into another, all the settings that you have made for the table will be lost. It is better to duplicate the table:
- Right click on the sheet you want to copy below.
- In the context menu, select "Move or copy ...".
- Then select a folder and the location to which you want to copy the data.
- Also activate the "Make a copy" option and click "OK".
To be able to copy and edit the data at any time, you must first remove the Excel sheet protection. We'll show you how.