When you create a PivotTable, if you put a field within the Report Filters section of the PivotTable, then you can later expand information to multiple worksheets based on that field. There is another way to expand information in a PivotTable, through the use of Report Filter pages. (This sounds the closest to what happened with Aziz.) ![]() (Remember that PivotTables are used to consolidate information they provide totals of information, so double-clicking "expands" that total so you can see what makes it up.)Īlso, if you double-click on a grand total in a PivotTable, Excel creates worksheets for each row that is included in that grand total. For example, if you double-click on a value in a row of the PivotTable, then Excel creates a worksheet that contains all the values that make up that original row value. Excel creates a new worksheet that provides detail for the value on which you clicked. ![]() One way to expand the data is to double-click on a value in the PivotTable. There are actually a couple of ways to expand the data in a PivotTable, but none of them involve keyboard shortcuts. Problem is, he cannot figure out what it was that he accidently pressed so that he can again do this on other PivotTables. After he got over the surprise, he found that this was very helpful in examining his data. ![]() Aziz once accidently pressed something while working with a PivotTable, which then expanded every row in the PivotTable to its own sheet.
0 Comments
Leave a Reply. |