From different excel files to one

Occasional Visitor

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)?

2 Replies



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.



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


If you want to copy one or more entire sheets:

  • Make sure that both workbooks are open in Excel.
  • Right-click the sheet tab of the sheet that you want to copy. If you want to copy multiple sheets, select them first, then right-click the sheet tab of any of the selected sheets.
  • Select 'Move or Copy...' from the context menu.
  • Select the target workbook from the 'To book' dropdown.
  • Specify where the sheets should be copied in the 'Before sheet' list box.
  • Tick the check box 'Create a copy'.
  • Click OK.