Nov 15 2020 11:07 PM
How to copy sheets from one book to another without resizing columns and rows, style? How do I get data from the original tables automatically (without copying)?
Nov 16 2020 12:29 AM
Copy the Excel table including settings
If you copy the contents of one table in Excel and paste it into another, all settings that you have made on the table will be lost.
It is better to duplicate the table:
Right-click at the bottom of the worksheet that you want to copy.
Select "Move or copy ..." in the context menu.
Then select a folder and the location to which you want to copy the data.
Also check the Make a Copy option and click OK.
Move or copy worksheets or worksheet data
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
Nov 16 2020 12:35 AM
If you want to copy one or more entire sheets: