Combining Excel Files Into One File With Multiple Worksheets - How to move & copy sheets (simplest method) the easiest method to merge excel spreadsheets is to copy one. In the function box, select the function that you want excel to use to consolidate the data. Web go to data > consolidate.
In the function box, select the function that you want excel to use to consolidate the data. Web go to data > consolidate. How to move & copy sheets (simplest method) the easiest method to merge excel spreadsheets is to copy one.