How To Consolidate Workbooks In Excel. Next, in the reference box, click the collapse button to shrink the panel and select the data in the worksheet. 6 ways to combine sheets in excel.
To select all sheets in a certain workbook, just put a tick in the box next to the workbook name, all the sheets within that excel file will be selected automatically.; In the combine worksheets wizard, select combine multiple worksheets from workbooks into one workbook option, and then click the next button. The function helps with data analytics and financial analysis.