Microsoft Office Tutorials and References
In Depth Information
Excel clears all the check boxes in the filter menu.
3. Select the Northwest check box, and then click OK .
Excel filters the PivotTable.
4. On the Quick Access Toolbar, click the Undo button.
Excel removes the filter.
5. In the PivotTable Field List task pane, drag the Weekday field header from the
Choose fields to add to report area to the Report Filter area in the Drag fields
between areas below area.
6. In the PivotTable Field List task pane, click the Close button.
The PivotTable Field List task pane closes.
7. In the body of the worksheet, click the Weekday filter arrow, and then, if necessary,
select the Select Multiple Items check box.
Excel adds check boxes beside the items in the Weekday field filter list.
8. Clear the All check box.
Excel clears each check box in the list.
Search JabSto ::

Custom Search