Excel table including all settings copying
If you copy in Excel the content of a table and in a different insert, be lost all of the settings you have made to the table. Better is to duplicate the table:
- Click with the right mouse button down on the worksheet you want to copy.
- In the context menu select "Move or copy...".
- Then select a folder and the location you want to copy the data.
- You can also activate the Option "create a copy" and click "OK".
Thus the data at any time, copy and edit, you must first find the Excel unprotect sheet. We will show you how to do that.