Options, choose the Advanced tab. In the Macro editor , click New > Merge, choose XLSX and add a name, select the worksheet in which you want to merge and click OK. Click the Add button on the toolbar where you can select multiple files and add them as a single worksheet, click OK to create a single .xlsx file from all the .xlsx files. Note: You can also use Excel Merge or .LSM merge from the menu. Choose the Excel file where you want to merge worksheets with. Select All .xls XLSX File from the list. Choose the Advanced tab. In the Macros editor, click New > Merge, choose XLSX and add a name, select the worksheet in which you want to merge and click OK. Click the Add button on the toolbar where you can select multiple files and add them as a single worksheet, click OK to create a single .xlsx file from all the. Select the selected files and click OK to save the merger. You can specify the file name and choose the name of the new file by clicking Save. For most .xlsx files, the Excel format, Excel 2010, Excel 2011, Excel 2024 and Excel 2024 are used.