Launch OpenOffice Calc and load the spreadsheet containing the cells you want to combine.Ĭlick the "Data" menu and select "Consolidate."Ĭlick the drop-down list under the label "Function" and select "Sum."Ĭlick the "Shrink" button in the "Source data range" section of the dialog box, select the first range of cells you want to combine, click the "Shrink" button on the "Consolidate: Source data range" window and then click the "Add" button.Ĭlick the "Shrink" button in the "Source data range" section of the dialog box, select the second range of cells you want to combine, click the "Shrink" button on the "Consolidate: Source data range" window and then click the "Add" button.
0 Comments
Leave a Reply. |