Data merge Setting up a data file in Excel to merge with InDesign
Excel Merge Data. For our example of adding. Use commas to separate the cells you are combining.
Data merge Setting up a data file in Excel to merge with InDesign
Web go to data > consolidate. Use commas to separate the cells you are combining. For our example of adding. The whole process takes only 2 quick steps:. In each source sheet, select your data. Select the cell you want to combine first. Web select the cell where you want to put the combined data. In the function box, select the function that you want excel to use to consolidate the data. Web you can merge worksheets from separate files, merge separate excel files into one, or use the consolidate feature to combine your data instead.
Select the cell you want to combine first. Web go to data > consolidate. In the function box, select the function that you want excel to use to consolidate the data. Select the cell you want to combine first. For our example of adding. In each source sheet, select your data. The whole process takes only 2 quick steps:. Use commas to separate the cells you are combining. Web you can merge worksheets from separate files, merge separate excel files into one, or use the consolidate feature to combine your data instead. Web select the cell where you want to put the combined data.
