![]() ![]() 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. Ctrl + Shift + 8 (number at top of keyboard). ![]() Keyboard shortcuts, to select all the body cells:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |