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 kommentar(er)
