excel for mac pivottable question

[sir42]

When I work with pivottables on my PC at work using Excel 2003, I can hide or unhide category rows by simply selecting the down arrow at the top of the category row, and selecting or deslecting the rows that I want to hide or unhide from a checklist.

However, when I'm working with the same excel pivottable on Excel 2004 for Mac, there is no down arrow at the top of the category row. Is there a way to hide and unhide category rows when using the pivottable on Excel 2004 for Mac?

thanks!

 

[geofflilley]

Field Settings

When I work with pivottables on my PC at work using Excel 2003, I can hide or unhide category rows by simply selecting the down arrow at the top of the category row, and selecting or deslecting the rows that I want to hide or unhide from a checklist.

However, when I'm working with the same excel pivottable on Excel 2004 for Mac, there is no down arrow at the top of the category row. Is there a way to hide and unhide category rows when using the pivottable on Excel 2004 for Mac?

thanks!

If you're talking about the row field, what you can do is right-click on one of the row field values, and choose "Field Settings." You can then hold down Command and select multiple values to hide.

If you're talking about the page field, no such luck. Your best bet for that is to create an additional column which differentiates the data in such a way that you can filter on a page field value. For example, if your page field contains state names (California, New Jersey, Nevada, Oregon, New York, New Hampshire, etc) and you want to see only the states in the Eastern Seaboard, then create an additional column in your data sheet called something like "region," with CA, NV, OR, WA, and AZ being the Pacific Northwest, and NJ, NY, MA, NH, and DE being the Eastern Seaboard. Then, make that "region" column the page field.