Double-click on the page field button, and you can select items to hide
or show.

There are some instructions he

http://www.contextures.com/xlPivot03.html#Page

Shashi Bhosale wrote:
I have a three choices on the page of the pivot table.
1. Site
2. Dept
3. Accounts

I limited to choose only one option from a choice. I want to select a range
instaed.
Ex. account range - 100010 - 100020; Dept : 1212 - 4444; Site : 001 - 999.

Is there a way to achieive this?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html