XL7: AutoCalculate in Group Edit Mode Works Only on Active SheetLast reviewed: September 2, 1997Article ID: Q135102 |
The information in this article applies to:
SUMMARYWhen you use group edit mode, the AutoCalculate feature applies only to the currently active sheet. This behavior is by design.
MORE INFORMATIONWhen you select a range on a worksheet, AutoCalculate allows you to quickly find information about the selected range; the sum, average, or count of the entries appears in the AutoCalculate area of the status bar. Group edit mode allows you to select multiple sheets and group them as a single object--use this feature to easily make global changes. A change made to any of the grouped sheets affects all other grouped sheets.
|
Additional query words: 7.00
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |