hello
i have 2 XLSX excel files with many tables i need to merge them in 1 excel worksheet
i am looking for the easiest way i cant afford to copy and paste all the DATA
any idea?shall i just copy the whole files  If you click on the corner of a worksheet, the box to the left of the column letters and at top of the row numbers, that will select the whole sheet.  Then, you can right click there and select Copy to copy the entire sheet.  You will see a moving dashed line appear around the sheet.

Then, go to the workbook and worksheet you want to copy to, again select an entire sheet, and then right click and select Paste.

Does that accomplish what you want to do?not really..because that will remove the sheet design which i spent a lot of time to arrange it  As a test, I used a small worksheet with column headings typed in row 1, which is underlined with a colored thick border line and to which I APPLIED Bold font.  Below the line are five cells CONTAINING text, data, or forumla, and formatted accordingly.  None of this formatting was lost when I copied the sheet to ANOTHER sheet.

Exactly what part of your "sheet design" are you losing when you use this procedure?oh that was true..a list appeared when i tried to paste and got the job done

thanks for help