![]() ![]() 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: Select any cell in the body of the pivot table.To select the entire pivot table body (not including the report filter range), follow these steps: There is a Pivot Table Shortcut Reference Chart in the next section, and here are a few details on using those pivot table keyboard shortcuts. Pivot Table Tutorials and Videos Keyboard Shortcut Notes ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |