Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 72 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 72

    Step 6    Click on Add button to insert the selected range in the Consolidation ranges field.

                      Step 7      Select additional ranges from different sheets and then click the Add button for each
                                selection.
                      Step 8        Click on the Shrink button next to Copy results to, to select the target cell range to
                                display the consolidated data from the above selected sheets’ data.
                      Step 9      Click on Options button. This will show Consolidate by including: Row labels and

                                Column labels check box and Options including Link to source data check box.
                      Step 10  Select Link to source data check box to update the values in the target cell range
                                with respect to the change in source cell range values. If you link the data, any values
                                modified  in  the  source  range  are  automatically  updated  in  the  target  range.  The

                                corresponding cell references in the target range are inserted in consecutive rows,
                                which are automatically ordered and then hidden from view. Only the final result, based
                                on the selected function, is displayed.

                      Step 11  Click on OK button to consolidate the ranges.

                      The data from the consolidation ranges and target range are saved when you save the sheet. If

                      you later open a sheet in which consolidation has been defined, this data will again be available.

                            GROUP AND OUTLINE

                      Group and Outline in Calc allows you to organise selected data by creating an outline, it lets you
                      group rows or columns together. This feature enables you to collapse (-) to hide data or expand
                      (+) it with a single click.

                     70     Premium Edition-VII

| 67 68 69 70 71 72 73 74 75 76 77 |