![]() The selected grouped pivot items can be in adjacent cell, or non-adjacentĬells (select the first cell, then press the Ctrl key while selecting To ungroup pivot items, select one or more groups on the worksheet, then press Alt + Key while selecting additional pivot item cells) The selected pivot items can be in adjacent cells, as in the screen shotīelow, or non-adjacent cells (select the first cell, then press the Ctrl To group pivot items, select them on the worksheet, then press Alt + NOTE: If you select a Row or Column item, instead of a heading, a calculated ![]() Heading where you want to add the item, then press Chtr + Shift + = To open the Calculated Item dialog box, select the Row or Column field To open the Calculated Field dialog box, select any field in the ValuesĪrea, then press Chtr + Shift + = (equal sign) ![]() NOTE: If a cell in the Report Filter range is selected, that range willīe selected, and none of the pivot table body range cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |