How to Allow the Selection of Multiple Items in Page Area of a Pivot Table

1. Open Excel 2007 and select a workbook. Click the 'Office' button and click 'Open.' Browse your computer and locate the workbook. Double-click the workbook. The workbook opens.
2. Highlight the data you want displayed in the pivot table. Select the 'Insert' tab. Click 'Pivot Table' twice. Click 'OK.' The blank pivot table appears in a new worksheet.
3. Add fields to the pivot table by checking the fields in the right 'Pivot Table Field List.' The fields appear in the column by default. Move some of the fields to the row by dragging the field name to the 'Row Labels' in the right 'Pivot Table Field List.' Add a field to the report filter by dragging the field name into the 'Report Filter' in the right 'Pivot Table Field List.'
4. Look above your pivot table to find the report filter. Click the drop-down list and select the option for 'Select Multiple Items.' This options allows for the selection of multiple items in your report filter page area.